Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Finding identifier whose given value is smallest

Hello I need your help for a simple issue I cannot solve... I have a table, named TBL below, that contains columns PR, FA and Prio. I need to create a new column RPR with content equivalent to Expec...
DAX
  • johnt75's avatar
    johnt75
    3 years ago

    You can use

    Calc PR = 
 VAR MinPriority = CALCULATE( MIN( 'Query1'[Prio]), ALLEXCEPT(Query1, Query1[FA]) )
 VAR Result = CALCULATE( MIN( 'Query1'[PR]), ALLEXCEPT(Query1, Query1[FA]), 'Query1'[Prio] = MinPriority)
 RETURN Result
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You can use

Calc PR = 
 VAR MinPriority = CALCULATE( MIN( 'Query1'[Prio]), ALLEXCEPT(Query1, Query1[FA]) )
 VAR Result = CALCULATE( MIN( 'Query1'[PR]), ALLEXCEPT(Query1, Query1[FA]), 'Query1'[Prio] = MinPriority)
 RETURN Result