Measure only affected by particular slicer

[Anonymous]

Hi Experts, 

In my dashboard, there is a Measure (Measure_Rank) which ranked the customer by frequency.  

Dax is as follow:

Frequency = DISTINCTCOUNT('Table'[Date])

Measure_Rank = 
VAR newtable =
SUMMARIZE ( ALLSELECTED ( 'Table' ), 'Table'[Customer ID] )
RETURN 
RANKX ( newtable, [Frequency],, ASC ) - 1

However, I want the Measure_Rank control by Date and Centre Code only, Pcode slicer cannot affect the Rank result. 
Wish anyone can help!! thank so much!!

Please find the PBIX here: RFM Demo 4.pbix

[Anonymous]

Hello @Jihwan_Kim 
see if you can help, my question here is the extension of my previous post. 

https://community.powerbi.com/t5/Desktop/Percentile-based-on-slicers-selection/m-p/2362811#M850494

[Greg_Deckler]

@Anonymous Can you not just edit the visual interactions? Format | Edit Iteractions and turn off the interaction with the table? Otherise, you should be able to use ALLEXCEPT or REMOVEFILTERS to remove the filters that you don't want.

[Anonymous]

@Greg_Deckler let me show you
I added Removefilters

However, it still affect the rank

[Anonymous]

@Greg_Deckler Thanks for your reply.
In my case I cannot use editing the visual interations, because the result is not the end, it will affect the latter part.

Actually I've tried Allexcept and removefilters as well, but it's failed, I cannot manage them well.

[Greg_Deckler]

@Anonymous You need to use REMOVEFILTERS in your SUMMARIZE so maybe something like:

VAR __Table = SUMMARIZE(CALCULATETABLE('Table',REMOVEFILTERS(...)), ...)

You can't use REMOVEFILTERS after the fact from your virtual table.

[Anonymous]

@Greg_Deckler OMG!
I just discover that the removefilters is work when date range is not applied.

However, when the date range slicer is applied, removefilters is totally disabled

What's the reason?

[Greg_Deckler]

@Anonymous Tough to say. Perhaps something with your date table is filtering your pcodes?