topic Re: IF() DAX not working in DAX Commands and Tips

IF() DAX not working

MCMM — Thu, 05 May 2022 09:05:28 GMT

Hi,

We are facing a really simple issue with IF() Dax. What we are trying to achieve is IF (A=0, B, A). For that, we created 3 measures:

A= amount for previous month

B = amount for before previous month

Last Closed Month = IF(A=0,B,A)

As you can see in the image below, both A and B measures work correctly, but the last closed month is retrieving A+B:

We tried to change the logic to =BLANK(), =””,<>0, <>BLANK()… but no matter what we do, the last measure keeps summing A+B.

Are we missing something here? We have never faced this issue with an IF statement before….

Re: IF() DAX not working

TOK — Thu, 05 May 2022 09:25:42 GMT

Hi MCMM,

well the total row uses your logic on its aggregation. As A Total > 0, it will take A Total for Last Closed Month Total as your if statement says.

Can you upload your file?

Liked this post? More Content on:
https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ

Re: IF() DAX not working

tamerj1 — Thu, 05 May 2022 11:01:34 GMT

Hi MCMM
What do you mean by (keeps summing)? If your problem is with the wrong total then you may try

Last Closed Month = SUMX ( SUMMARIZE ( DateTable, DateTable[Year], DateTable[Month] ), CALCULATE ( IF ( A = 0, B, A ) ) )

Re: IF() DAX not working

v-xiaotang — Fri, 03 Jun 2022 09:56:01 GMT

Hi MCMM

The if function in table visual is fine, it is working properly. If you don't want the total in the total row, you can either turn it off or use hasonevalue() or hasonefilter() or isfiltered() to customize the value in the total

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.