Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |