Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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?