cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with IF function

Since I have installed June 2019 update of Power BI, the IF function can not resolve the table and column names; when I try to write a measure.

 

I tested the SUM function and it can resolve the table name and columns but IF function can't.

 

I tried uninstalling and reinstalling but it didn't help.

 

Any clues? Thanks.

Status: New
Comments
Moderator

Hi @amoljoshi7

 

Would you please share some screenshot so we can understand the issue better? 

 

Which DAX do you use to create the measure? When we use the IF() function to create a measure, we need to use aggregation functions inside of the IF() function, eg: count, sum, max,...,etc. 

 

Best Regards,
Qiuyun Yu