Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

Calculation error in measure (only in web; working fine in desktop version)

I'm getting this error in the web version of my report: powerbi error.PNG

 

The measure returns VALUES(table[column]), but first checks if there is only a single value:

 

Brand =
  IF(
  HASONEVALUE(product_dimension[Brand name]);
  VALUES(product_dimension[Brand name]);
  BLANK()
)

 

The error doesn't occur in the desktop version.

Status: Delivered
Comments
v-qiuyu-msft
Community Support

Hi @ChristianW,

 

I'm not able to reproduce the issue on my side. Please try to publish our test pbix file to your Power BI service to check if it works fine.

 

Best Regards,
Qiuyun Yu 

ChristianW
Regular Visitor

Hi @v-qiuyu-msft,

 

the test pbix works fine.

In our pbix I replaced VALUES(product_dimension[Brand name]) with FIRSTNONBLANK(product_dimension[Brand name];1) which returns the same result and it's working now.

But still strange that a measure that has been working for months and wasn't changed suddenly causes an error for all of our customers.

 

Best Regards,

Christian W.

v-qiuyu-msft
Community Support

Hi @ChristianW,

 

I guess the original issue should related to the report or Power BI service itself. To find a root cause, you can create a support ticket to get dedicated support. 

 

Support Ticket.gif

 

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Status changed to: Delivered