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

parry2kLet's say I wanted to get DC4-Tank A as my result.  

 

The visuals are already set to a page filter of DC4, so that gets rid of the DC2 results.

 

If I filter to Day_Tank = TRUE, I now have seven results

 

Now the minimum value of INDEX of that filter would give me my expected result.

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

tkrupka so basically you need minimum of index on allselected records

 

Minimum Index = 
CALCULATE( MIN(Table[Index]) , ALLSELECTED( Table ) )

 

 

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