In my sales table I created a percentage measure that can give me the percantage of sales for each category the code is below:
VAR total_count =
CALCULATE ( SUM ( Sales[Units] ) , ALL ( Sales[Product Category] ), ALL ( Sales[Sold Date] ), ALL ( Sales[Delivered Date] ) )
(DIVIDE(SUM(Sales[Units]),total_count)) * 100
Next step was to display all my columns in a table with the % field
|product category||units||%||latest sold_date||latest delivered_date|
Next I want to filter the above to show only those product categories where % > 10%. How would I be able to achieve this?
UPDATE: Have solved how to do the above you just use the measure in the filter pane, but have another requirement whereby need to have an others group for % under 10% so if someone can show me how to do this I have seen other examples and it looks like may need a calculated table. I know the above example only shows one category under 10% but the above is only dummy data.