Forum Discussion

m_wex's avatar
m_wex
Icon for Helper I rankHelper I
5 years ago

Ranking Output

Trying, unsuccessfully, to display a customer ranking list using the following:   Customer Ranking  = IF(NOT(ISBLANK([Total Sales])), if([Total Sales]>0.01,RANKX(ALLSELECTED(Customers[Customer N...
ranking
m_wex's avatar
m_wex
Icon for Helper I rankHelper I
5 years ago

Solved the issue by putting a filter on the field so that no blanks are displayed, But how do you prevent a rank on the total line? The table shows all the ranked customers and provides total sales. But it also shows a 1 in the ranking column. Is the function hasonevalue the one to use?

AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
5 years ago

m_wex  You can use ISINSCOPE to check the if the Customers[Customer Name] is being used for grouping in the visual. IF ( ISINSCOPE  ( Customers[Customer Name] ), [Your Measure] )