DAX to group <5% as other

[martijnvanderveldt]

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!

 

[ImkeF]

Hi Martin,
ABC-Analysis technique should give you the ability to split your groups up into 2 segments. Then you can expand one & keep the other one collapsed, if this would work for you:

Power Pivot: ABC Classification
Power Query: ABC Analysis with Power Query - Powered Solutions