cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
merelvstr Regular Visitor
Regular Visitor

IF merged cells are blank give ...

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
 
 
 
 
1 ACCEPTED SOLUTION

Accepted Solutions
vanessafvg Super Contributor
Super Contributor

Re: IF merged cells are blank give ...

@merelvstr

 

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

 

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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

View solution in original post

2 REPLIES 2
vanessafvg Super Contributor
Super Contributor

Re: IF merged cells are blank give ...

@merelvstr

 

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

 

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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

View solution in original post

merelvstr Regular Visitor
Regular Visitor

Re: IF merged cells are blank give ...

Thank you for the fast answer!

This worked!

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 353 members 3,437 guests
Please welcome our newest community members: