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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
rpinxt
Solution Sage
Solution Sage

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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