DAX Measure for Distinct top 3 Fruits per Quarter

[xcaliber044]

Hi Community,

I am seeking assistance in achieving these figures using the DAX measure. Different top 3 fruits should be captured for each quarter. Is it possible? Thank you in advance!

[FBergamaschi · Accepted solution]

Create this measure

Sales Top 3 =

VAR Top3Prod =

TOPN (

    3,

    ALL ( Fruit[FruitName] ),

    [Sales]

)

RETURN

CALCULATE( [Sales], KEEPFILTERS( Top3Prod ) )

put the quarter column (I sugget year-quarter) in Columns and the fruit column in Rows in a matrix

Thanks

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

View solution in original post