PowerBI Dax - Display row based on certain condition

Hi Anonymous ,

You will need to create two independent table as below and use these two tables as slicers.

Company = DISTINCT('Table'[Company Name])

Vessel = DISTINCT('Table'[Vessel Name])

Then create a measure as below and add it to visual filter set value = 1.

Measure = 
var T_company = SELECTEDVALUE('Table'[Company Name])
var T_vessel = SELECTEDVALUE('Table'[Vessel Name])
var C_company = SELECTEDVALUE(Company[Company Name])
var V_vessel = SELECTEDVALUE(Vessel[Vessel Name])
var T_status = SELECTEDVALUE('Table'[Status])
return
SWITCH(TRUE(),
    ISFILTERED(Company[Company Name])&&ISFILTERED(Vessel[Vessel Name]),
        IF(T_company=C_company&&T_vessel=V_vessel&&T_status="FALSE",1,0),
    NOT(ISFILTERED(Company[Company Name]))&&ISFILTERED(Vessel[Vessel Name]),
        IF(T_vessel=V_vessel&&T_status="TRUE",1,0),
    NOT(ISFILTERED(Company[Company Name]))&&NOT(ISFILTERED(Vessel[Vessel Name])),
        IF(T_status="TRUE",1,0))

Best Regards,

Jay