Forum Discussion
kirbynguyen
Helper II
Helper IIReport Page Tooltip displaying the wrong value
Hello, I am creating a scatterplot using X and Y values and then I calculate the predicted value through linear regression in DAX and then calculate the residual between the predicted value and the Y...
Hi kirbynguyen ,
Is Residual a measure or a calculated column? Please try to create a measure Residual as below and check if you can get the correct result...
Measure = SUM([Y Value]) - [Predicted Value]
If the above one is not your expected result, please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards