Forum Discussion
Dynamic rank with slicer
Hi,
I have following data
| Client | Product | Source | Balance |
| a | 1 | X | 100 |
| b | 1 | X | 200 |
| c | 2 | Y | 140 |
| d | 2 | Y | 234 |
| e | 3 | X | 456 |
| f | 3 | X | 251 |
I need to create dynamc rank for Balance that changes based on the slicer. I want my table (created on dashboard) based on slicer for product and source. If i select product '1'. this is how the table should look like:
| Rank | Client | Product | Source | Balance |
| 2 | a | 1 | X | 100 |
| 1 | b | 1 | X | 200 |
If i select product '2' it changes to this
| Rank | Client | Product | Source | Balance |
| 2 | c | 2 | Y | 140 |
| 1 | d | 2 | Y | 234 |
If i select both, it should look like this:
| Rank | Client | Product | Source | Balance |
| 4 | a | 1 | X | 100 |
| 2 | b | 1 | X | 200 |
| 3 | c | 2 | Y | 140 |
| 1 | d | 2 | Y | 234 |
Same is the case with source.
Can someone help.
Thanks in Advance.
Anonymous Please try this as a "New Measure"
Test129 = RANKX(ALLSELECTED(Test129DynamicRnk),CALCULATE(SUM(Test129DynamicRnk[Balance])),,DESC,Dense)
2 Replies
- PattemManohar
Community Champion
Anonymous Please try this as a "New Measure"
Test129 = RANKX(ALLSELECTED(Test129DynamicRnk),CALCULATE(SUM(Test129DynamicRnk[Balance])),,DESC,Dense)