Reply
avatar user
Anonymous
Not applicable

Measures not calculating correctly after refresh in Web Service, but do in Desktop

I'm encountering an issue where measures I'm building populate correctly in Desktop and initially in the Web Service, but return a (blank) value after the dataset is refreshed in the Web Service. 

 

The below example shows a table with one of my measures in Desktop:

zhausle_0-1635967264032.png

And the same table in the Web Service post-refresh:

zhausle_1-1635967475896.png

 

The code for this measure is as follows: 

 

Email Open Rate = CALCULATE(SUM('Donor Communications Report - Emails This Year Summary Stats'[Count]),'Donor Communications Report - Emails This Year Summary Stats'[Opened]="TRUE")/SUM('Donor Communications Report - Emails This Year Summary Stats'[Count])
 
And the measure is based on columns in two tables that are related in the Desktop model by an email ID many-to-many relationship.
 
Thank you all for any help you can provide!

 

 

2 REPLIES 2
v-angzheng-msft
Community Support
Community Support

Hi, @Anonymous 

 

Have you tried refreshing your data in the power bi desktop, if you get the same result in the desktop as in the service (blank value), then it means that there is no problem with the measure, but your data.

 

In addition, it's hard for someone to find the cause of the problem very clearly in a situation where there is no sample to test only a description of the problem.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

avatar user
Anonymous
Not applicable

Bump....

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric Community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)