Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Request your guidance to solve this issue;
Below screenshot shows the salesman wise sales for the month of August, 2022. I would like to grade them as "A", "B","C" based on the criteria like this;
Grade A = Top 4 ( Waseem/Jaffer / Ammar / Khurram )
Grade B = Top 5 to 8 ( Fawad / Jaber / Shakeel / Shabbir )
Grade C = below 9 ( Balance all salesman )
Kindly advise
regards,
dsmitha
Solved! Go to Solution.
Hi @dsmitha ,
According to your description, here is my solution.
Create a column to rank the “Count of SIM”.
rank = RANKX ( 'Table', 'Table'[Count of SIM],, DESC )
Create a measure to assign Grade A, B, C according to the rank.
Grade = SWITCH ( TRUE (), MAX ( 'Table'[rank] ) <= 4, "A", MAX ( 'Table'[rank] ) >= 5 && MAX ( 'Table'[rank] ) <= 8, "B", "C" )
Final output:
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dsmitha ,
According to your description, here is my solution.
Create a column to rank the “Count of SIM”.
rank = RANKX ( 'Table', 'Table'[Count of SIM],, DESC )
Create a measure to assign Grade A, B, C according to the rank.
Grade = SWITCH ( TRUE (), MAX ( 'Table'[rank] ) <= 4, "A", MAX ( 'Table'[rank] ) >= 5 && MAX ( 'Table'[rank] ) <= 8, "B", "C" )
Final output:
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-xiaosun-msft,
thanks a lot, excellent solution, exactly what i was looking for
double kudoz !
regards,
dsmitha
@dsmitha Use RANKX to create a ranking. Create another measure that uses the ranking with a SWITCH(TRUE()...) statement to return your A, B, C.
User | Count |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |