Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

PowerBI Dax - Display row based on certain condition

I got two filter (Company Name & Vessel Name) and one table as below; I got three condition to fulfil

 

 

First one, if company name and vessel name filter is selected at same time, table will show detail with status FALSE, As example, Jimmy and Ali Anca shown with fail status

 

Second condition is, if only vessel filter is selected, table will show detail with only TRUE status. As example, when Ali Anca is selected, table show Ali Anca with TRUE status;

 

 

Third condition is, when both filter is not selected, All data will be shown on table with only TRUE status as below;

 

Really appreciate if anyone can help

  • Anonymous's avatar
    Anonymous
    4 years ago

    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