Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Convert row into value

Dear DAX collegues,   I stumbled over a - maybe - trivial problem, but cannot solve it:   I'd like to create a measure that give the name of the product with max production duration per day. I'v...
  • Stachu's avatar
    Stachu
    8 years ago

    you can use the syntax you posted as filter parameter in CALCULATE

    Measure = 
VAR Top1 = TopN(1,'Products',Products[Minutes],DESC)
RETURN
CALCULATE(FIRSTNONBLANK(Products[Product],TRUE),Top1)
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
8 years ago

Hi Anonymous

 

You may try to use below measure:

Measure =
CALCULATE (
    VALUES ( 'Product'[Product] ),
    TOPN ( 1, 'Product', 'Product'[Minutes], DESC )
)

 

Regards,

Cherie