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 wi...
  • 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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous ,isfiltered can help

Try a measure like

measure =
Switch( true() ,
isfiltered(Table[Companyname]) && isfiltered(Table[VessalName]) , calculate(countrows(Table) , filter(Table, Table[Status] = FALSE())),
isfiltered(Table[Companyname]) && isfiltered(Table[VessalName]) , calculate(countrows(Table) , filter(Table, Table[Status] = TRUE()))
)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Should this measure place on visual filter (table)?

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , it can be placed with all un summarized columns, then it will filter data. If there is any other measure you can also use it as a visual level filter