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  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!