Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have the following measure and what do I add to show only the Top 5?
@bdehning , use a visual level filter, filter this for <=5
else create a TOPN -TOPN: https://youtu.be/QIVEFp-QiOk in place of rank
I got that to work but I get ties and end up with more than 5 values. As I use [Count of Total Gross Incurred] for the first calculation, how can I add the next calculation to check the [Sum of Total Gross Incurred] to break ties to stay at 5 or less?
TOPN can also deal with ties.
-- TOPN might return more than the requested rows in presence of ties.
EVALUATE
TOPN (
3,
ADDCOLUMNS (
VALUES ( 'Product'[Product Name] ),
"@Sales Amount", MROUND ( [Sales Amount], 500000 )
),
[@Sales Amount],
DESC
)
ORDER BY [@Sales Amount] DESC
-- Multiple sorting criteria can be provided in further parameters.
EVALUATE
TOPN (
3,
ADDCOLUMNS (
VALUES ( 'Product'[Product Name] ),
"@Sales Amount", MROUND ( [Sales Amount], 500000 )
),
[@Sales Amount],
DESC,
[Product Name],
ASC
)
ORDER BY [@Sales Amount] DESC
I already have a Top N in my Table to Select top 5 Cities.
I need to create a new measure that can check Count of an item first and then use the highest sum of each item to break ties.
This is what gets me the Top 5 when I use "Is Less than or greater to 5"
Now I need to be able to break ties by taking the highest Sum of counts that tie. I will be using LossRunToExcel[Sum of Total Gross Incurred]
Ideas?
Hi, @bdehning
Not sure what you mean.
Can you share your sample data and expected result? It's easier to take a look at the problem.
Best Regards,
Community Support Team _ Eason
Can you close this string out. I had to work on another string.
User | Count |
---|---|
86 | |
83 | |
67 | |
61 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
84 | |
70 |