Forum Discussion

StatsChick's avatar
StatsChick
Frequent Visitor
5 years ago

Changing Sales Ranks Depending on Slicer

Hi,    Please do train me if I'm not asking with the right syntax.   I have a table:   Customer ID  Sales  Category 1                     $1000    Foo 1                          $40    Bar 2 ...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi StatsChick ,


According to the information you currently provide, there may be a problem with the creation of your Rank measure. I did the following test, which can be used as a reference. The created Rank is based on the clientID classification to obtain sum_sales for judgment. Get a summary table, and then filter according to category slicer, everything shows normal.

 

Total sales = CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[client]))
Rank = IF([Total sales]>=100,"Fabulous","Ordinary")

 

If the problem is still not resolved, please provide detailed error information and right demand. Let me know immediately, looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

StatsChick's avatar
StatsChick
Frequent Visitor
5 years ago

Thank you for taking a look, Henry. However, I have mixed categories for each client. So client 1 has $40 if you choose the Bar category, and would then be marked Ordinary; but has $100 in the Foo category, and would be marked Fabulous if I am choosing either all categories or just Foo.

 

I need the sum to re-sum according to my several slicers, and then I need a dynamic ranking variable.

 

Does that make sense?