Forum Discussion
Solved
Creating a Ranking for measures - with visual filters
Hello Everyone, I have the following table: Make Dates Criteria Count BMW 01/01/2022 broken door 10 BMW 01/01/2022 broken handles 20 Mercedes 01/01/2022 no lights 10 ...
Hi Gladiator909 ,
Here are the steps you can follow：
1. Create measure.
Sum_Measure = SUMX( FILTER( ALLSELECTED('Table 1'),'Table 1'[Criteria]=MAX('Table 1'[Criteria])),'Table 1'[Count])Rank = RANKX( ALLSELECTED('Table 1'),[Sum_Measure],,ASC)2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Gladiator909 ,
Here are the steps you can follow：
1. Create measure.
Sum_Measure =
SUMX(
FILTER(
ALLSELECTED('Table 1'),'Table 1'[Criteria]=MAX('Table 1'[Criteria])),'Table 1'[Count])Rank =
RANKX(
ALLSELECTED('Table 1'),[Sum_Measure],,ASC)2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly