Top N filter not working along with other measure filter.

[Reddy567]

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?

[Anonymous]

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.

[nsexton12 · Accepted 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!

[Reddy567]

Thanks a lot @nsexton12 . It worked.