Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I intend to achieve "Table 2" outcome. However, my DAX isn't working as expected. Table 2 was achieved using the TopN function from the filter pane.
How do I achieve "Table 2" using DAX?
Here is my DAX command for "Table 1"
Solved! Go to Solution.
1. Create a measure called 'Sum Values' to SUM the Values
2. Create a measure Ranking to rank the for the SUM Values
Hi harshnathani,
Thanks for your response. It does work. However, I've got 2 questions for you;
1. Total isn't correct. It is showing the total for everything and not the top 2.
2. Is it possible to achieve this using TOPN?
Please use this measure.
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |