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.
Probably a real easy one. I'm trying to filter a visual to show the top 3 values of a column based on a random number measure RAND(). The picture shows the exact setup. Clearly it's not limiting the visual to the top 3 random numbers. Ultimatel, the visual won't have the random number column on it but I put it there for illustrative purposes. Thoughts?
@DJBAJG , USe top N measure
example
2 column top N = CALCULATE([Net], TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[Brand], 'Item'[Category]), [Net],DESC),VALUES('Item'[Brand]), VALUES('Item'[Category]) )
2 column top N = Sumx(Keepfilters( TOPN(10, SUMMARIZE(ALLSELECTED('Item'), 'Item'[Product Category], 'Item'[Product Name]), [Total_sales],DESC)), [Total_sales])
Use your columns
Check
Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ
I'm going to need more clarification. I understand the TOPN function but I'm not sure how your examples get me where I need to be with my specific issue.
I must use the random number as the driver of the TOPN. Every time I make a slicer selection I need rows displayed to change. That's the whole point. It needs to be random. I don't have the ability to build out measures for each value I need to dispaly in the table.
So apparently this isn't possible?
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |