Difference between TABULAR MODEL SQL SERVER DATA and Power Bi Data Dumps

[Karolina411]

Hello

Trying to work out the difference to come up with the same result from simple division:

There is a $43 difference paginated Reports (filtered by YearMonth in my DateDim table)
=Sum(Fields!AllowedCostYTD.Value, "DataSet1")/Sum(Fields!MemberMonthsYTD.Value, "DataSet1") $413

=IIF(IsNothing(Sum(Fields!AllowedPMPMYTD.Value)),0,Sum(Fields!AllowedPMPMYTD.Value)) 513.96

[Sum(AllowedPMPMYTD)] = 513.96 -- 663 into

=Sum(Fields!AllowedCost.Value, "DataSet1")/Sum(Fields!MemberMonthsYTD.Value, "DataSet1") 69.71

IN CUBE: AllowedPMPMYTD:=[AllowedCostYTD]/[MemberMonthsYTD] $370

IN CUBE: AllowedCostYTD:=TOTALYTD([AllowedCost],DateDim[DateValue])
IN CUBE:MemberMonthsYTD:=TOTALYTD([MemberMonths],DateDim[DateValue])

IN CUBE: BloodPressureDenominator:=SUM([CbpInDenominator])

Visual:

Report Builder Below

Power Bi Below

[Anonymous · Accepted solution]

Hi, @Karolina411 

This difference is mainly caused by the inconsistency between the context of your current paginated report and the normal Power BI report.
You need to check all the filters of your paginated report and make sure that the two reports use the same filters.
The easiest way to check whether your formula has problems is to put the required columns into two reports, and then all the filters are the same to verify whether your expression has problems.
If your expression has no problems, the reason for this difference is that you are currently using other fields (columns) or there are other filters in Power BI Desktop.
In general, paginated reports and Power BI reports use different languages, and their calculation logic is also different. You need to adjust and calculate according to the characteristics of paginated reports.

Best Regards

Jianpeng Li

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