IF() DAX not working

[MCMM]

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

[v-xiaotang · Accepted solution]

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.

[tamerj1]

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 ) )
)

[TOK]

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