cancel
Showing results for
Did you mean:
Post Patron

## Top 30 Records Logic in Analysis services

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?

1 ACCEPTED SOLUTION
Super User

Hi,

Try this measure

Top 30 orders = calculate([revenue],top(30,all(Orders[Order number]),[revenue]),values(Orders[Order number]))

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
3 REPLIES 3
Community Support

Hi @ja832153 ,

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:

Best Regards

Lucien

Super User

Hi,

Try this measure

Top 30 orders = calculate([revenue],top(30,all(Orders[Order number]),[revenue]),values(Orders[Order number]))

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

Hey @ja832153 ,

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

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Announcements

#### Launching new user group features

Learn how to create your own user groups today!

#### Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors