Hello team. I'm trying to do a variable filter based abc analysis. I have a table: Factory, Year, SKU, sales. At the moment, abc analysis of SKU-sales only works for me. How to make so that the boundaries of this analysis are based on the other two dimensions, which will be chosen by the user in the diagram. (User picks factory or year and ABC analysis change) Aggr( If(Rangesum(Above(Sum({1} [Sales])/Sum({1} total [Sales]),1,RowNo()))<0.8, 'A', If(Rangesum(Above(Sum({1} [Sales])/Sum({1} total [Sales]),1,RowNo()))<0.95, 'B','C')), ([SKU], (= Sum({1} [Sales]) ,Desc) ) )
