Returning Top 10 Products with SSAS Multi Dimensional as a Data Source

[Kieran]

Hi,

I have a requirement to return Top 10 products with SSAS Multi Dimensional as a Data Source.

I am aware of that you can't expose named sets to a Power BI model ...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6706390-custom-and-named-sets-sup...

and you can't change the model within a Power BI desktop file which connects to a 

SSAS Multi Dimensional Data Source so I understand that I won't be able to create a DAX RANK expression in this scenario.

Is there any way around this so I can delivery Top 10 Products where the Power BI data source is a SSAS Multi Dimensional Cube?

Kind Regards,

Kieran.

[MFelix · Accepted solution]

Hi @Kieran,

If you want to make the top 10 now you can use this feature in the filter option if you had the field you want to filter in the visual or page and then select type of filter top n you can then select the n and also the field to wich do top filter.

Regards

Mfelix

[Kieran]

Thanks MFelix.