topic Re: DAX to show 2 IF Statements in one field in DAX Commands and Tips

DAX to show 2 IF Statements in one field

Anonymous — Tue, 12 Nov 2024 08:32:09 GMT

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

Re: DAX to show 2 IF Statements in one field

BeaBF — Tue, 12 Nov 2024 08:35:52 GMT

Anonymous 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

Re: DAX to show 2 IF Statements in one field

ValtteriN — Tue, 12 Nov 2024 08:41:37 GMT

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/

Re: DAX to show 2 IF Statements in one field

Anonymous — Tue, 12 Nov 2024 09:24:54 GMT

Thanks BeaBF : it worked perfectly! 🙂