Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 , 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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
108 | |
104 | |
83 | |
73 |