Forum Discussion

IvanS's avatar
IvanS
Icon for Helper V rankHelper V
4 years ago
Solved

LOOKUP within the same table

Hey guys,   I browsed several sources about how to lookup value within the same table, however any of those met my requirements.   I have one huge agile table that consists of stories (sub-tasks)...
Need Help
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    I see, for a measure MAX() or SELECTEDVALUE() should solve the issue:

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

IvanS  you can use this measure

Measure =
VAR _epicName =
    MAX ( 'Table 1'[Epic Link] )
RETURN
    CALCULATE (
        MAX ( 'Table 1'[Epic Name] ),
        FILTER ( ALL ( 'Table 1' ), 'Table 1'[Issue_Unique Key] = _epicName )
    )

 

 

IvanS's avatar
IvanS
Icon for Helper V rankHelper V
4 years ago

Hi smpa01 

 

for some reason, the function is not working in measure. Please find below - the names in official file are a bit different. You can see that calculated column is getting the Epic name however measure is blank (except one line from the list).