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)
Stachu's avatar
Stachu
Community Champion
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)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Great! Works absolutly fine!

Thanks, Stachu!