Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @Redraidas1 ,
You could consider to create a measure using RANKX() function.
Then add this measure to filter to filter the data that rank value is less than 10.
For example:
_sum = SUM('Table'[value])
_rank = RANKX(ALL('Table'),[_sum])
Best Regards,
Jay
Hi @Redraidas1 ,
You could consider to create a measure using RANKX() function.
Then add this measure to filter to filter the data that rank value is less than 10.
For example:
_sum = SUM('Table'[value])
_rank = RANKX(ALL('Table'),[_sum])
Best Regards,
Jay
@Redraidas1 it is not as straightforward as it looks like, you are doing top 10 on a table and also filtering on another table. Also what are your expectation when you are seeing the data below, let's say we want the top 3 (would you like to see (200 + 40 + 30, = 270 since these are top 3 values ), or you want it to sum by the customer and then take top 3 in that case from the data below the result will be (A = 15, B = 30, C = 200, D = 70 and top 3 will be then 200 + 70 + 30 = 300)
A - 10
A - 5
B - 20
B - 10
C - 200
D - 30
D - 40
It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Use this Function
VAR = RankofABC = Rankx(all(AfterSales_BM[ColumnName]),sum(abcvalue))
return
calculate(sum(abcvalue),filter(all(all(AfterSales_BM[ColumnName]),RankofABC<=10),distinct(columname))
Proud to be a Super User!
Proud to be a Super User!
I changed it, but the problem is still there.
DAX:
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |