Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

How to filter those sales drop customer ?

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%20sales%20drop%20customer.pbix?dl=0

 

Paul 

 

 

 

 

 

 

Paul Yeo