cancel
Showing results for 
Search instead for 
Did you mean: 

Q&A returns wrong result for simple measure

Hi

 

I have 2 reports:

  1. Report A = with imported data
  2. Report B = live connection with Power BI dataset from report A

So report A en B are build on the same data and show exactly the same data in the report.

 

When I ask the same questions in report A en B I sometimes get different results while no different filters are active.

I can test this very easily as other measures return the correct values.

 

For example:

Q&A1.PNG

 

 

Q&A2.PNG

 

 

Measure Budget:

Budget = 
CALCULATE (
    SUM ( Meetwaarden[Budget positief]);
     ALL ( Datum[Kwartaal] ) 
)

 

This looks as a bug to me as Q&A should return the same result for questions asked with imported data or a live connection to that Power BI dataset.

 

Friendly greets

Sven

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @svenvu

 

From the measure Budget, there should be two tables Meetwaarden and Datum, please share some sample data of these two tables so we can try to test it on our side. 

 

Best Regards,
Qiuyun Yu