Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filter Top N customers using slicer

Hi everyone,   I have a table containes customerID and sales amount. I want use the sales amount and growth rate to create a scatter chart.  I hope that the users can select top 10, 20, 50 customer...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Is Top X selected? =
IF (
    RANKX (
        ALL ( 'DataTable'[Customer ID] ),
        CALCULATE ( SUM ( 'DataTable'[Sales Amount] ) ),
        ,
        DESC,
        DENSE
    )
        <= SELECTEDVALUE ( ParameterTable[Value] ),
    "Yes"
)

 

You must specify what to group them by, in this case you are ranking them by Customer.

venkatasuresh_g's avatar
venkatasuresh_g
Icon for Helper IV rankHelper IV
6 years ago

Anonymous   

 

Thanks , that fixed the issue. I amnot sure how the sample working with out mentioning the field to group by. 

 

Suresh Guddanti