Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I would like to create a measure which pulls the top 30 order numbes based on revnue in analysis services tabular model . This data should be pulled from the main fact table and dimension tables.
How to create TOP30 records logic measure in the analysis services without creating any additional tables/Columns?
Solved! Go to Solution.
Hi,
Try this measure
Top 30 orders = calculate([revenue],top(30,all(Orders[Order number]),[revenue]),values(Orders[Order number]))
Hope this helps.
Hi @Anonymous ,
Test the following measure:
revnue Measure
revnue_m = SUM(Ranking[revnue ])
revnue Rank
revnueRank = RANKX(ALL(Ranking),[revnue _m],,DESC,Skip)
TotalSalaryTop30Rank
revnueTop30 = CALCULATE([revnue_m],FILTER(Ranking,[revnueRank ]<=30))
refer:
https://community.powerbi.com/t5/Desktop/Top-10-based-on-a-measure/m-p/460956
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi,
Try this measure
Top 30 orders = calculate([revenue],top(30,all(Orders[Order number]),[revenue]),values(Orders[Order number]))
Hope this helps.
Hey @Anonymous ,
I think you are looking for the TOPN function: TOPN – DAX Guide
Then you can check if a certain order number is in the TOP 30, flag this order number and filter for the flag.
Hopefully, this gets you started.
Regards,
Tom
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |