Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
Trying to make a (I thought) simple TopN measure like :
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.
Solved! Go to 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! 🙂
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 :
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! 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
87 | |
71 | |
63 | |
60 |