Top 10 Dashboard with Multiple Slicers

[Anonymous]

Hi all good afternoon

I´ve being looking and trying all solutions I could find, but I’m still facing problems, so I would like to see if you can help me.

Request: I need a dynamic top 10 dashboard that returns depending on the selected filters “Slicers” the top 10 elements.

Obs: The slicer elements aren’t at the same table, but they are all related to the fact table

Additional Information: Not sure if it can be reached out with Rank function, what I already had tried, with the following formula (IF ( HASONEVALUE ( Products[Corp] ),RANKX ( ALLSELECTED ( Products[Corp]  ), CALCULATE(FACT[CURRENT MAT VALUE]), [CURRENT MAT VALUE],0,Dense))… but so I have a single context, and I need it to create a new one whenever the user choose a slicer element, or by row count.

Dinamyc Top 10 wit Slicers

[v-shex-msft]

HI @Anonymous,

I'd like a pbix file with some sample data for test and coding formula.(you can upload it to onedrive or google drive and share link here)

Regards,

Xiaoxin Sheng

[Anonymous]

I had reduced the data volume and it now work in desktop mode, when I have it published them it doesn't work as expected and as in desktop mode...

I will try to set a sampledatabase and share the examples with you

Thank you

[Anonymous]

I had reduced the data volume and it now work in desktop mode, when I have it published them it doesn