HI Team,
Have a question regarding Dynamic Group customers by Ranking
In that Sam created disconnected table for Top 5 and 5-20 and the rest and he created DAX formula as below
Didnt understand how this formula works and y he used count rows can any one help me understand in a better highly appreciated
CALCULATE([Total Sales] ,FILTER(VALUES(Customer_Data[Customer Names]),
COUNTROWS( FILTER(‘Customer Ranking’,
RANKX(ALL(Customer_Data),[Total Sales],DESC) > ‘Customer Ranking’[MIn] &&
RANKX(ALL(‘Customer_Data’),[Total Sales],DESC)<= ‘Customer Ranking’[Max]))>0))
Thanks,
varun G