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?
