Forum Discussion

Ang0zyx's avatar
Ang0zyx
Frequent Visitor
4 years ago

DAX code to filter topn

Hi everyone, Could you please help me to convert the below query to dax.the idea is to filter the overall top3 products and show for all countries.   SQL: Select country,product,sales from SalesT...
DAX
power bi
TopN
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure how your data model looks like or how your desired outcome looks like, but please try the below.

 

 

new measure: =
CALCULATE (
    SUM ( SalesTable[sales] ),
    KEEPFILTERS (
        TOPN (
            3,
            ALLSELECTED ( SalesTable[product] ),
            CALCULATE ( SUM ( SalesTable[sales] ) ), DESC
        )
    )
)