DAX to group <5% as other

martijnvanderveldt

New member
Joined
Sep 10, 2014
Messages
10
Reaction score
0
Points
0
Hi Guys!
I was wondering whether you now of a DAX formula or DAX measure that I can use in Power BI Desktop (power Query) to make sure all groups lower than 5% are grouped together and call them "other" while the others are just the same as normal. Secondly, maybe a bit next level, is that i want this to be working with the slicing I use so that the grouping is not always the same depending on the slicing

You guys would be of great help.
Thanks!
 
Unfortunately I am working in Power BI Desktop which does not gives me all the normal futures of Excel. It looks quite similar to power query yet I can't go back to the sourcefile and change things since it will mess up the query. Thus, I can solely work in the query editor and either create and extra column or measure. Would you know any formula that could pull it off?
 
Back
Top