Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
rankx function does rank by class and number of days but you can not see the first position
Ranking = RANKX ( ALLEXCEPT('Table';'Table'[car_class];'Table'[days]); CALCULATE ( SUM ( 'Table'[ttl_cost] ) ) ;;ASC;Dense)
Solved! Go to Solution.
Try thie MEASURE
Ranking2 = RANKX ( CALCULATETABLE ( rent_201904230843, ALLEXCEPT ( rent_201904230843, rent_201904230843[car_class], rent_201904230843[days] ) ), CALCULATE ( SUM ( rent_201904230843[ttl_cost] ) ), , ASC, DENSE )
Try thie MEASURE
Ranking2 = RANKX ( CALCULATETABLE ( rent_201904230843, ALLEXCEPT ( rent_201904230843, rent_201904230843[car_class], rent_201904230843[days] ) ), CALCULATE ( SUM ( rent_201904230843[ttl_cost] ) ), , ASC, DENSE )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |