Forum Discussion
Different values between dynamic report and paginated report
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!
3 Replies
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?