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!
Go to Solution.
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:
View solution in original post
Thanks for sharing😊.
Paul Zheng _ Community Support Team
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?
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.