Forum Discussion
IvanS
Helper V
Helper VLOOKUP 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)...
I see, for a measure MAX() or SELECTEDVALUE() should solve the issue:
IvanSHelper V
Helper VHi 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
Community Champion
Community ChampionI see, for a measure MAX() or SELECTEDVALUE() should solve the issue: