Different values between dynamic report and paginated report

[Anonymous]

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! 

[Anonymous]

@Anonymous 

Thanks for sharing😊.

Paul Zheng _ Community Support Team

[Anonymous · Accepted solution]

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: 

[Anonymous]

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?