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 to filter Count(Orderid)>50 and then display Top 10 Products based on Total Sales Amount Desc.
I have created Measure for count(Orderid) and applied filter Measure>50 and Applied visual lever Top 10 filter on Product based on Total Sales amount.
But first Top N filter is applying and later Measure>50 filter is getting applied. Can we change this order to apply Measure>50 first and later Top N filter?
Solved! Go to Solution.
You could create another measure that filters out all products where count < 50, and put that in the filter for your TOPN calculation as well as the table. This will ensure that no values less than 50 will ever reach the TOPN filter.
For example:
IF(COUNT(Table[OrderId]) < 50, 0, SUM(Table1[Sales]))
If this works for you, please mark as a solution!
Hi @Reddy567 ,
Try formula like below:
result_ =
CALCULATE (
MAX ( 'Count'[Value] ),
KEEPFILTERS (
TOPN ( 3, FILTER ( ALL ( 'Count' ), 'Count'[Orderid] > 50 ), 'Count'[Value] )
)
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You could create another measure that filters out all products where count < 50, and put that in the filter for your TOPN calculation as well as the table. This will ensure that no values less than 50 will ever reach the TOPN filter.
For example:
IF(COUNT(Table[OrderId]) < 50, 0, SUM(Table1[Sales]))
If this works for you, please mark as a solution!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |