RANKX / TOPN Measure Needed

DAX DAX Calculations
1

Hi,
I am trying to create a measure that will provide a Total based on TOPN with 2 filters.
The attached .pbix has a table that provided a Total =39 based on choosing a Plan and choosing a date.
I am needing a measure that would provide the same total to utilize in other aggregations.
Any help or suggestions would be greatly appreciated.
tks/

RANKX and TOPN Measure Needed.pbix (2.3 MB)

2

@cs566

Try this that I used in one of my reports.

Top Ranking Pattern =

VAR Top5 = RANKX(
ALL( Locations[Location City] ),
[Total Sales],
DESC
)

RETURN
IF(
Top5 <= 5,
[Total Sales],
BLANK ()
)

3

Thanks for your response @Paul.Gerber!

Hi @cs566, did the suggestion provided above solve your query? If so, kindly tag the post by Paul as “Solution”. Thanks!

4

Hi Paul,
I appreciate you sharing your measure, but unfortunately it didn’t work in my data model. Still on search for solution.

5

Hi @cs566, while waiting for other members to jump in, I suggest using the forum search to discover if your query has been asked before by another member. Thanks!

6

Hi @cs566! We noticed that your inquiry was left unsolved for quite some time now.

Looks like your inquiry was out of the experts and members’ bounds.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done.

Thank you!