March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
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
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
I had reduced the data volume and it now work in desktop mode, when I have it published them it doesn
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
109 | |
73 | |
55 | |
52 | |
44 |
User | Count |
---|---|
157 | |
113 | |
63 | |
60 | |
50 |