Forum Discussion
Paginated Report Numbers Don't Match Standard Power BI Report
I have a Power BI Standard Report and a Paginated Report that are showing different numbers for the same calc and I can't figure out why.
On the paginated report (to the left below), the value is always a little more.
- They both pull from the same data in the database.
- They both calculate the measures exactly the same way.
- The only difference in the data is.... PowerBI pulls directly from the database, the Paginated pulls from a Scematic Model in Power BI of the Power BI Report.
The paginated report uses a Evalutate Summarize columns command to create the table for all dates.
EVALUATE SUMMARIZECOLUMNS('Date Table (Weekends)'[Month Name], 'Date Table (Weekends)'[Year], 'Date Table (Weekends)'[Month], "% Collected", [% Collected])We also have separate Tablix for each year on the Paginated
Here are the calc's for the Numbers (these calc's and measures are the same on both datasets.
% Collected = Amount Collected / Total Funded - Fees
% Collected = DIVIDE([Amount Collected],[Total Funded-Fees])
Amount Collected =
CALCULATE(
SUM('CollectedMonthlyBalancexDealData'[CollBal]),
FILTER(
ALLSELECTED('CollectedMonthlyBalancexDealData'[DealMonth]),
ISONORAFTER('CollectedMonthlyBalancexDealData'[DealMonth], MAX('CollectedMonthlyBalancexDealData'[DealMonth]), DESC)
)
)
Total Funded-Fees = [Total Funded]-[Total Fees]
Total Funded
Total Funded =
CALCULATE(
SUMX(ADDCOLUMNS(
SUMMARIZE(
CollectedMonthlyBalancexDealData,
CollectedMonthlyBalancexDealData[deal_id],
"First Amount", FIRSTNONBLANK(CollectedMonthlyBalancexDealData[advance_amount], 0)
),
"Amount", [First Amount]
),
[Amount]),ALLSELECTED(CollectedMonthlyBalancexDealData[DealMonth]))
Total Fees =
CALCULATE(
SUMX(ADDCOLUMNS(
SUMMARIZE(
CollectedMonthlyBalancexDealData,
CollectedMonthlyBalancexDealData[deal_id],
"First Fee", FIRSTNONBLANK(CollectedMonthlyBalancexDealData[Total Fees], 0)
),
"Fee", [First Fee]
),
[Fee]),ALLSELECTED(CollectedMonthlyBalancexDealData[DealMonth]))
Hi, mattsuderman
You are using the same metrics in two reports with different results, then the problem is not the definition of the metrics, but their application or interpretation in different reports. The problem is not the definition of the metrics, but their application or interpretation in the different reports, because the metrics depend on the current context. You can try to check the following to troubleshoot the problem step by step:
First check for problems with the two data source links. You mentioned that you are using the semantic model in the paging report. You need to make sure that the data in the whole model correctly reflects the data from the data source, which you can check by linking to your semantic model using DAXstudio, a helper tool.
You also need to check the filters and slicers. In both reports, make sure that all slicer filters are applied correctly. This is because they change the context of the data and the aggregated results.
In addition, you mentioned that you created a date table using EVALUATE SUMMARIZECOLUMNS to make sure that the data generated is the same as in the other report.
In addition, you need to check the date ranges to make sure that the date ranges that both report metrics depend on are the same. You can test this by creating a new, simple report that contains only the metric values that are causing the inconsistency, which can help you quickly identify the problem.How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
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.
1 Reply
Hi, mattsuderman
You are using the same metrics in two reports with different results, then the problem is not the definition of the metrics, but their application or interpretation in different reports. The problem is not the definition of the metrics, but their application or interpretation in the different reports, because the metrics depend on the current context. You can try to check the following to troubleshoot the problem step by step:
First check for problems with the two data source links. You mentioned that you are using the semantic model in the paging report. You need to make sure that the data in the whole model correctly reflects the data from the data source, which you can check by linking to your semantic model using DAXstudio, a helper tool.
You also need to check the filters and slicers. In both reports, make sure that all slicer filters are applied correctly. This is because they change the context of the data and the aggregated results.
In addition, you mentioned that you created a date table using EVALUATE SUMMARIZECOLUMNS to make sure that the data generated is the same as in the other report.
In addition, you need to check the date ranges to make sure that the date ranges that both report metrics depend on are the same. You can test this by creating a new, simple report that contains only the metric values that are causing the inconsistency, which can help you quickly identify the problem.How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
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.