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 ...
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:
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?