Filtering top 100 customers using a live cube connection

[Alejandroo]

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 to be able to create a slicer or filter of some sort where I filter the entire page to bring data for only the top 100 customers based on my Revenue Measure. The cube of course has many many dimensions and Customers is just one of them. I do not want to create a slicer where I have to manually select 100 customers, so is there a way to do this with a slicer or creating some sort of measure with DAX?

Thank you

[amitchandak · Accepted solution]

@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]

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.