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
venkatasuresh_g's avatar
venkatasuresh_g
Helper IV
6 years ago

Hi ,

 

 I am working on same issue , I ran in to the same problem as you . Can you please let us know how  you were able to fix it. It will help people who come to this thread with same question 

 

Thanks

Suresh

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
    Helper 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