The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
@Power_MN , this is a column rank
Try measure rank
Rank = RANKX(allselected(Table1[product]) ,calculate(Sum(Table1[Quality])),,DESC,Dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
or my video -https://www.youtube.com/watch?v=DZb_6j6WuZ0
@Power_MN , measure rank is context-sensitive. if you add any other than product like product id, it will become 1.
Geography Rank = RANKX(all(Geography[City]),[Sales])
Geography Rank = RANKX(all(Geography),[Sales])
City and ID Rank = RANKX(all(Geography[City],Geography[City Id]),[Sales])
In these examples with city id , first one will give rank 1 only.
Try to give table name to combination of columns
@Power_MN , this is column rank. I suggested measure.
Try like this
rankx(filter(table, [supplier] =earlier([supplier] )), [quality],,desc, dense)
Also, refer to link I shared
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
8 | |
8 |