Trying to Show Spend % and if less than 10%, it shows other

[dgilm33]

I am calculating spend% and trying to show the category name for anything above 10%, and show as other if below 10%.

I have a calculated measure getting total spend for each category:

Sum Category = SUM('CategoryTable'[Total Spend])

I have a calculated mesaure getting the total spend:

Sum Total Spend = Calculate([Sum Category], ALL('CategoryTable'[Other Column]))

I have a calculated measure getting the spend %:

Spend % = Divide([Sum Category, Sum Total Spend])

Now I'm trying to create the column to either show the category name or other:

Other Column = IF([Spned %]<.10, "Other", 'CategoryTable'[Category])

The Spend % is calculating correctly for each category. However, the Other column is not showing correct and is still showing all categories regardless of %.

[AlexisOlson]

These might help:

https://goodly.co.in/top-n-and-others-power-bi/

https://www.sqlbi.com/articles/showing-the-top-5-products-and-others-row/

[PijushRoy]

Hi @dgilm33 

Can you please share excel sample data here