DAX to show 2 IF Statements in one field

[Anupal]

Hello,

I have 2 Flag fields(working as slicers and Containing values as YES and NO). I need to write a DAX including both flag fields in a IF condition such as WHEN these slicers are selected as YES then my measure should show as BLANK.

Eg:--(Below DAX I created but its not working)

Forecast Revenue =
VAR SelectionP = SELECTEDVALUE(DT_Table1[Custom flag 1])
VAR SelectionT = SELECTEDVALUE(DT_Table2[Custom flag 1])
RETURN
IF (
SelectionP = "Yes",
BLANK(),
IF (
SelectionT = "Yes",
BLANK(),

CALCULATE(
[Forecast Revenue], FT_Forecast[Fiscal Calendar[Quarter Aging]]]=0
)
))

Any help will be appreciated.

Thanks 

AP

[BeaBF · Accepted solution]

@Anupal Hi! Try with:

Forecast Revenue =
VAR SelectionP = SELECTEDVALUE(DT_Table1[Custom flag 1])
VAR SelectionT = SELECTEDVALUE(DT_Table2[Custom flag 1])
RETURN
IF (
SelectionP = "Yes" || SelectionT = "Yes", -- Check if either of the flags is "Yes"
BLANK(),
CALCULATE(
[Forecast Revenue],
FT_Forecast[Fiscal Calendar[Quarter Aging]] = 0 -- Corrected the filter condition
)
)

BBF

[Anupal]

Thanks @BeaBF : it worked perfectly! 🙂

[ValtteriN · Accepted solution]

Hi,

Here is one way to do this:

Measure 31 = var _sel1 = SELECTEDVALUE('Table (45)'[Column1])

var _sel2 = SELECTEDVALUE('Table (44)'[Column1])

RETURN

SWITCH(TRUE(),_sel1 = "Yes" && _sel2 = "Yes",BLANK(),

10000)

Now if both selections are yes the value is blank. You can add different cases like this:

Measure 31 = var _sel1 = SELECTEDVALUE('Table (45)'[Column1])

var _sel2 = SELECTEDVALUE('Table (44)'[Column1])

RETURN

SWITCH(TRUE(),_sel1 = "Yes" && _sel2 = "Yes",BLANK(),

_sel1 = "No" && _sel2 = "Yes",100,

10000)

Place your measure where 10 000 value is.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[BeaBF · Accepted solution]

@Anupal Hi! Try with:

Forecast Revenue =
VAR SelectionP = SELECTEDVALUE(DT_Table1[Custom flag 1])
VAR SelectionT = SELECTEDVALUE(DT_Table2[Custom flag 1])
RETURN
IF (
SelectionP = "Yes" || SelectionT = "Yes", -- Check if either of the flags is "Yes"
BLANK(),
CALCULATE(
[Forecast Revenue],
FT_Forecast[Fiscal Calendar[Quarter Aging]] = 0 -- Corrected the filter condition
)
)

BBF