Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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:
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |