Forum Discussion

tkrupka's avatar
tkrupka
Icon for Resolver II rankResolver II
7 years ago
Solved

DAX If And Filter

I am trying to figure out how to do this.  Basically I am trying to write a DAX equation that will allow me to create a measure with multiple filters.     I want to get the Tanks[Tank_Name] ...
Need Help
  • tkrupka's avatar
    tkrupka
    7 years ago

    Finally figured out what I wanted.  I'm not sure why I was having such an issue.

     

    Day_Tank_1 = CALCULATE(VALUES(Tanks[Tank_Name]),FILTER(Tanks,Tanks[Day_Tank]=TRUE()),FILTER(Tanks,Tanks[INDEX]=1))
tkrupka's avatar
tkrupka
Icon for Resolver II rankResolver II
7 years ago

parry2kBut I also need to filter based on the Day Tank value because some visuals will be based on TRUE and others will be based on FALSE on the same dashboard.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

tkrupka I would recommend put your data in excel sheet and required result in a seperate sheet to get you the solution. I sent you an post before on how to get answer quickly, hope you already read it. 

  • tkrupka's avatar
    tkrupka
    Icon for Resolver II rankResolver II
    7 years ago

    parry2k I haven't seen it.

  • tkrupka's avatar
    tkrupka
    Icon for Resolver II rankResolver II
    7 years ago

    Finally figured out what I wanted.  I'm not sure why I was having such an issue.

     

    Day_Tank_1 = CALCULATE(VALUES(Tanks[Tank_Name]),FILTER(Tanks,Tanks[Day_Tank]=TRUE()),FILTER(Tanks,Tanks[INDEX]=1))