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:

     

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!