IF merged cells are blank give ...

[Anonymous]

Hello all,

I have been searching around the forum but couldn't find the solution for my case:

I merged 3 columns from the query 'RezReporting' into the query 'RAReporting'. The four columns I merged were called:

- Rental Days

- Total Bill Tax 1 Charge

- Total Bill Surcharge Charge

- Total Bill Rate Charge

Then I wanted to make a measure with these 4 and for those that did not have a match I want to use another measure created earlier called 'Res RpD (RA Report)'. This is what I had so far in my measure:

Res RpD (Rez) =

VAR

ResRpDRez = SUMX(RAReporting,RAReporting[RezReporting.Total Bill Tax 1 Charge]+RAReporting[RezReporting.Total Bill Surcharge Charge]+RAReporting[RezReporting xlsx.Total Bill Rate Charge])/SUM(RAReporting[RezReporting.Rental Days])

RETURN

    IF(ResRpDRez=BLANK(),[Res RpD (RA Report)],ResRpDRez)

So it looks like the BLANK() is not being recognized band being replaced if blank because even if I would use only the variable in another measure without the if statement, I have exactly the same result...

Can someone help me with this?

Very much appreciated!!

Regards,

Merel

[vanessafvg · Accepted solution]

@Anonymous

i find isblank works better in some scenarios (can't rememer the reason why)

IF ( ISBLANK ( ResRpDRez ), [Res RpD (RA Report)], ResRpDRez )

[Anonymous]

Thank you for the fast answer!

This worked!