Forum Discussion

Alejandroo's avatar
Alejandroo
Microsoft Employee
2 years ago
Solved

Filtering top 100 customers using a live cube connection

Hello, I have built a report using desktop with several views connecting to a Live Cube that I only have read access. I have created a lot of measures in my report and they all work fine, but I need ...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Alejandroo , You can use TOPN Filter at visual level

     

    or create a measure on a revenue measure

     

    M1=  calculate([Revenue], keepfilters(topn(10, allselected(Table[Customer]), [Revenue], desc)  ) )

     

    TOPN: https://youtu.be/QIVEFp-QiOk
    TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448

amitchandak's avatar
amitchandak
Super User
2 years ago

Alejandroo , You can use TOPN Filter at visual level

 

or create a measure on a revenue measure

 

M1=  calculate([Revenue], keepfilters(topn(10, allselected(Table[Customer]), [Revenue], desc)  ) )

 

TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448

Alejandroo's avatar
Alejandroo
Microsoft Employee
2 years ago

Thank you very much, the Top N didn't work but the new measure work's perfect. I would've preferred the Top N but for some reason it does not apply the filter to the values, maybe the cube has some limitations on that. At some point I was even considering adding a slicer that allowed me to toggle between top 100, top 500, top 10, but I believe that was not possible either.