Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
rpinxt
Power Participant
Power Participant

TopN in Dax not working

Trying to make a (I thought) simple TopN measure like :

Top5_BO_Qty = TOPN(5,'Backorder Details',[BO Qty],DESC)
 
But getting this error:
rpinxt_0-1665754058396.png

Anybody that can help me out and tell me whats wrong and how to fix?

 

I want the Top 5 on field PF name (it will not let me choose that field only the table Backorder details) based on BO Qty.

1 ACCEPTED SOLUTION

Sorry, i was just looking at the function and forgot to calculate the measure.

 

This works

 

Top5_BO_Qty = 
CALCULATE(
    [BO Qty],
    KEEPFILTERS(
        TOPN(
            5,
            ALL('Backorder Details'[PF Name]),
            [BO Qty],
            DESC
        )
    )
)

 

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

View solution in original post

6 REPLIES 6
jcalheir
Solution Supplier
Solution Supplier

Hi

 

Do this

Top5_BO_Qty =
    TOPN(5,
    ALL('Backorder Details'[yourfield]),
    [BO Qty],
    DESC)

 

 Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

Thanks @jcalheir 
Did this :

Top5_BO_Qty = TOPN(5,
    ALL('Backorder Details'[PF Name]),
    [BO Qty],
    DESC)
** How did you get that grey box around your code?
 
But still no luck:
rpinxt_0-1665755320490.png

It is a card, so just to check the one value measure.

Is it possible to share your PBIX file so we can take a look?

Ok had to throw out a lot because it work data, but still the field from the measure are there and also the error.

So hopefully this example is enough to solve it.

 

I cannot add a file here so I put it on drive:

https://drive.google.com/file/d/1wGjxsuFgUAG-q1CgvvEMfSy4zGzjy-Nc/view?usp=drivesdk

Sorry, i was just looking at the function and forgot to calculate the measure.

 

This works

 

Top5_BO_Qty = 
CALCULATE(
    [BO Qty],
    KEEPFILTERS(
        TOPN(
            5,
            ALL('Backorder Details'[PF Name]),
            [BO Qty],
            DESC
        )
    )
)

 

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

Thanks @jcalheir  this works fine 😁

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.