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:

     

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

Hi,

Like you suggested Lookup is the way to go here is my DAX:

Epic = LOOKUPVALUE(Epics[Epic Name],Epics[ssue_Unique Key],Epics[Epic Link])

I am not sure if I am missing something, but the column returned matches your desired outcome:


I hope this helps to solve your issue and if it does consider accepting this as a solution!

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

Hi ValtteriN ,

 

yes, this is pulling the data into table - yet I need to add it into Matrix - for hiding the data on aggregated level in matrix I am using measure that consists of ISFILTERED.

 

IF(ISFILTERED(Issues[ISSUE_KEY]), SELECTEDVALUE(Issues[ISSUE_CURRENT_TYPE_NAME]), BLANK())

 

When creating your function as column, Power BI is automatically setting First with options Last, Count & Distinct count. Is there any way how to hide this information (or at least to write your function as measure)?

 

The main issue with measures is that they cannot work with duplicate values and giving the below error.

 

 

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

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