topic Re: Different values between dynamic report and paginated report in Report Server

Different values between dynamic report and paginated report

Anonymous — Thu, 06 May 2021 16:13:04 GMT

Hello,

I'm having a hard time understanding why I see different results in the dynamic (Power BI desktop) report and in the Paginated report for the same measure.

This is the matrix that I have created as a reference for my calculations:

The User % sums up to 100% for any row, which is what I wanted. This is the code I used:

In the paginated report created from the same dataset, this is my matrix:

The first probnlem I found was that somehow whenever I run the report, I find SUM([User_]) in the % field, which I removed manually. But even then, the User % value shows 100% for all columns:

Any idea of why this is happening?

Thanks in advance!

Re: Different values between dynamic report and paginated report

Anonymous — Thu, 06 May 2021 19:52:19 GMT

So... I made a bit of progress, as the issue seems to be that ALLSELECTED doesn't work in the paginated report. I substituted it with ALLEXCEPT (which is not my strong suite):

Now my problem is that, while the % is correct for those rows/columns where there is a value, where there are blanks, it replicates a random result from another row:

How do I fix this?

Re: Different values between dynamic report and paginated report

Anonymous — Fri, 07 May 2021 13:49:51 GMT

Update:

I haven't found a fix for the DAX formula, but I have decided in the end to calculate the % with an expression in the Report Builder:

Now my table looks like this:

Re: Different values between dynamic report and paginated report

Anonymous — Mon, 10 May 2021 05:49:37 GMT

Anonymous

Thanks for sharing😊.

Paul Zheng _ Community Support Team