DAX If And Filter

[tkrupka]

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] where Tanks[Day_Tank]=FALSE && Tanks[INDEX]=MIN(Tanks[INDEX]) following the Day Tank filter

i.e.  if Day_Tank=FALSE, Lookup Tank_Name where Index is smallest value.

The reason for this is because I am going to have visuals on the same dashboard where Day_Tank = True and Day_Tank = FALSE

I've been playing around with this for a few days now without success.

[parry2k]

@tkrupka if you share sample data with expected result it will help to provide the solution. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[tkrupka]

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

[parry2k]

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

[tkrupka]

@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]

@tkrupka so basically you need minimum of index on allselected records

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

[tkrupka]

@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]

@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 · Accepted solution]

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]

@parry2k I haven't seen it.