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

parry2k IF Fourth column = TRUE / FALSE depending on the situation, give me the 2nd column where the last column is the smallest value.

 

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

tkrupka minimum of last column against whole dataset or what?? Can you clarify? 

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