Dynamic rank with slicer

[Anonymous]

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.

[PattemManohar · Accepted solution]

@Anonymous Please try this as a "New Measure"

Test129 = RANKX(ALLSELECTED(Test129DynamicRnk),CALCULATE(SUM(Test129DynamicRnk[Balance])),,DESC,Dense)

[Anonymous]

Hi @PattemManohar,

That was helpful.

Thanks 🙂