Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I have the following table visual below and I want to slice it by Region, Industry and a range of dates that are related to each client in a table visual without Power BI recalculating the rankings, the fields ranking sales and ranking amount are dax measures:
Client List | Ranking Sales | Ranking Amount |
Client1 | 19 | 1 |
Client2 | 20 | 2 |
Client3 | 21 | 3 |
Client4 | 22 | 4 |
Client5 | 23 | 5 |
Client6 | 24 | 6 |
Client7 | 25 | 7 |
Client8 | 26 | 8 |
Client9 | 1 | 9 |
Client10 | 2 | 10 |
Client11 | 3 | 11 |
Client12 | 4 | 12 |
Client13 | 5 | 13 |
Client14 | 6 | 14 |
Client15 | 7 | 15 |
Client16 | 8 | 16 |
Client17 | 9 | 17 |
Client18 | 10 | 18 |
Client19 | 11 | 19 |
Client20 | 12 | 20 |
Client21 | 13 | 21 |
Client22 | 14 | 22 |
Client23 | 15 | 23 |
Client24 | 16 | 24 |
Client25 | 17 | 25 |
Client26 | 18 | 26 |
So for example I want to slice so the table only returns client2 and two as follows:
Client List | Ranking Sales | Ranking Amount |
Client2 | 20 | 2 |
Client3 | 21 | 3 |
Currenly the table is returning:
Client List | Ranking Sales | Ranking Amount |
Client2 | 1 | 1 |
Client3 | 2 | 2 |
Is this possible to keep the desired result being able to slice using the range of dates, region and industry and keeping the ranking?
I don't want to hard code the rankings because the user may change the range of dates and we want it to recalculate but I want to be able to filter by client list column. What Dax functions can I use for the Rankx to be able to filter?
Solved! Go to Solution.
Hi,
I do not know how you used RANX DAX function in the measure. I assume you used ALLSELECTED DAX function.
If my assumption is correct, please try using ALL DAX function.
Thank you very much, you are right, I was using Allselected
Hi,
I do not know how you used RANX DAX function in the measure. I assume you used ALLSELECTED DAX function.
If my assumption is correct, please try using ALL DAX function.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |