How to filter those sales drop customer ?

[admin11]

Hi All

@Ashish_Mathur provide me the below expression , enable to rank my cusotmer sales for 2019 and 2020. 

Now i like to know how what is the faster to filter those customer have drop ? i have create a field Rank Yr Vari field to compute the ranking changes. since this field is a measure i am not able to place at filter Pan.

My PBI file :-

https://www.dropbox.com/s/zxz02hav2kev9gj/PBT_V2021_392%20TI_SI_GL%20how%20to%20filter%20those%20sal...

Paul 

Paul Yeo

[Ashish_Mathur · Accepted solution]

Hi,

The filter works just fine.

[admin11]

@Ashish_Mathur 

Thank you very much for your help.

Paul

[Ashish_Mathur]

You are welcome.