Dynamics Segmentation / Dynamic Ranking

DAX DAX Calculations
1

Hi
Ive been watching the video on dynamic ranking / segmentation and try to recreate with my data however the Top and Bottom Customer Sales Values do not equal the Total sales figure

Any ideas as to why? Page 6 of this model
Customer Attrition Test.pbix (479.7 KB)

image
image551×503 16.7 KB

2

Hello @AliB,

Thank You for posting your query onto the Forum.

The reason why - “Top Customers + Bottom Customers <> Total Sales” is because if you see the measure for “Bottom Customers” the measure contains the condition as “Total Sales > 0”, if you remove that condition i.e. “> 0” then “Top Customers + Bottom Customers = Total Sales”. Below is the revised measure for Bottom Customers alongwith the screenshot of the final results provided for the reference -

Botton Customers = 
CALCULATE( [Total Sales] ,
      TOPN( [Total Customers] - [Customer Rank Value] ,
           FILTER( VALUES( Customers[Group] ) , [Total Sales] ) , [Total Sales] , ASC ) )

Final Results
Final Results1044×701 33.1 KB

I’m also attaching the working of the PBIX file for the reference purposes.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Customer Attrition Test - Harsh.pbix (478.7 KB)

3

Thank you Harsh

4

Hello @AliB,

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to assist you.

Thanks and Warm Regards,
Harsh