Forum Discussion

jitpbi's avatar
jitpbi
Icon for Post Patron rankPost Patron
5 years ago

if with multiple conditions

Hi,   the below is the sample of my data, where table name is "Table":   Device Name Status DateTime A Healthy 10/15/2020 16:05:10 PM B Healthy 10/15/2020 14:05:10 PM A Faulty ...
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

Create a measure:

MeasureD = VAR maxDate = MAX(TableQ[DateTime])
VAR badTab = FILTER(TableQ, TableQ[Status] = "Faulty" && TableQ[DateTime] = maxDate)
RETURN
    IF (COUNTROWS(badTab) > 0, "faulty", "Not")

Put it on a table with Device

 

For best performance, you should use a separate date and time table but this might work as it is.

jitpbi's avatar
jitpbi
Icon for Post Patron rankPost Patron
5 years ago

Hi HotChilli ,

 

Actually i needed it to show in the pointer ilke: "Device ABC is faulty currently"

so the device name should come dynamically and rest text can be static.

 

Thanks