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).

     

     

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

      IvanS  can you provide a sample pbix?

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

        I found the root cause of the issue - there was bilateral relationship between 2 tables which are part of matrix table. After change to sigle filterring, the both measures are working. 

         

        I will mark measure from ValtteriN as solution as it is not that much performance consuming. However thank you too for help!