measure result is a specific row, show the text from another cell in that same row in a new tile

[eric_s]

Hello Power BI Community,

Can somebody help me with my problem?

In my Excel table of 5 colums I gather incident information. 

Table name; YTD_Status_Overview

On a PowerBi tile I show Date information of when the last incident (LastYesMAASTRICHT) is reported, 03/01/2021 in this case.

Measure code;  

LastYesMAASTRICHT = CALCULATE(LASTDATE(YTD_Status_Overview[Date_Of_Incident]),FILTER(YTD_Status_Overview,[Set]="Yes"))

Of that same row I want to show the Comment information (injury test 03-01) on another tile. What would be the code for this measure?

Thanks in advance, Eric

[Pragati11 · Accepted solution]

Hi @eric_s ,

Based on just seeing the data in your screesnhot as I can't try it because you haven't attached the sample data file, Just try the following measure:

LastIncident = 

var lastDate = CALCULATE(LASTDATE(YTD_Status_Overview[Date_Of_Incident]), FILTER(YTD_Status_Overview,[Set]="Yes" ))

RETURN

CALCULATE(MAX(YTD_Status_Overview[Comment]), FILTER(YTD_Status_Overview, [Set]="Yes" && YTD_Status_Overview[Date_Of_Incident] = lastDate))

Thanks,

Pragati

[Pragati11 · Accepted solution]

Hi @eric_s ,

Based on just seeing the data in your screesnhot as I can't try it because you haven't attached the sample data file, Just try the following measure:

LastIncident = 

var lastDate = CALCULATE(LASTDATE(YTD_Status_Overview[Date_Of_Incident]), FILTER(YTD_Status_Overview,[Set]="Yes" ))

RETURN

CALCULATE(MAX(YTD_Status_Overview[Comment]), FILTER(YTD_Status_Overview, [Set]="Yes" && YTD_Status_Overview[Date_Of_Incident] = lastDate))

Thanks,

Pragati

[eric_s · Accepted solution]

Thank you very much Pragati, your code works in my dashboard.
Gr, Eric

[Pragati11]

Hi @eric_s ,

If the above solution works, please Accespt it as a solutions so that others can be also benefit from it.

Thanks,

Pragati