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

Karolina411 — Thu, 18 Jul 2024 18:29:35 GMT

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

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

Anonymous — Fri, 19 Jul 2024 06:46:51 GMT

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.

topic Re: Difference between TABULAR MODEL SQL SERVER DATA and Power Bi Data Dumps in Report Server

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

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