cancel
Showing results for 
Search instead for 
Did you mean: 
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
Moderator

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 

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.

Moderator

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