Refresh Correlation Coefficient

[Ad0m1n]

Hi all,
We have a measure that calculate the correlation coefficient. In the Power BI Desktop this measure is working correctly, but when we refresh the report in the service, the measure lose the values.

the code of the measure is:

When the report is published in the service, the values ​​are correct. The following table show the values.

But we refreshing the report, the service shown the same table but the values of the measure correlation coefficient are blank.

Is there any solution?

Thank you very much

[v-lid-msft]

Hi @Ad0m1n ,

If your issue still does not resolved, we suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lid-msft]

Hi @Ad0m1n ,

Can you see the data of Recommendation Num and Value Number column in Power BI Service when put then into a table visual? What connection mode you used in this document? Have you meet this issue in this report before?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ad0m1n]

Hi @v-lid-msft 

 This error ocurr from several months. Also the values ​​are not show in any table visual, it's as if the calculeted measure is not executed. We load data from a sql server database with import option.

Thank al lot.

[v-lid-msft]

Hi @Ad0m1n ,

If you miss data after refresh in Power BI Service. Could you please check the refresh history and the connoction status of gateway?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi there

That might be the case when there is something in your PBIX after refreshing that is causing the numbers to change.

Make sure that you do not have any parameters in the Power BI Service?

[Ad0m1n]

hi @GilbertQ 

 Thank you very much for the replay, but the pbix  or the service haven't any parameters.