Showing results for 
Search instead for 
Did you mean: 

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 =
  HASONEVALUE(product_dimension[Brand name]);
  VALUES(product_dimension[Brand name]);


The error doesn't occur in the desktop version.

Status: Delivered

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 


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.


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

Established Member
Status changed to: Delivered