Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to display only top 10 in the table and have been looking up to try using TOPN and RANKX.
But i have been having issue with rankx, with it displaying 1 rank across the table.
The table is expected to be filtered by three criteria,
1. main_service
2. direction
3. customer_segment
I have tried using adding columns and it gives me the ranks throughout the entire table. But i am looking for a dynamic ranking where it will be ranked as the filter is applied.
rank = RANKX(ALLSELECTED(summary_table), [total_teus],,0)
rank is using new column with the above code, while rankings, i have been trying with code below.
rankings = CALCULATE(
RANKX(ALLSELECTED(summary_table[od_pairs]), SUM([total_teus]),,0))
Solved! Go to Solution.
@jeanL , Try TOPN like
CALCULATE([total_teus], TOPN(10,ALLSELECTED(summary_table[od_pairs]),[total_teus],dense), ALLSELECTED(summary_table[od_pairs]))
rankings =
RANKX(
ALLSELECTED( summary_table[od_pairs] ),
CALCULATE( SUM( [total_teus] ) )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
rankings =
RANKX(
ALLSELECTED( summary_table[od_pairs] ),
CALCULATE( SUM( [total_teus] ) )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
@jeanL , Try TOPN like
CALCULATE([total_teus], TOPN(10,ALLSELECTED(summary_table[od_pairs]),[total_teus],dense), ALLSELECTED(summary_table[od_pairs]))
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |