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.
Hi,
I have a simple table... Have a look... The only change I did was from changing the Data Type from Decimal DNumber to Fixed decimal number... Suddenly the total gets negative with the "% of Grand Total" calculation failing as well...
Any idea what's going wrong? Are the numbers to high so that Power BI gets confused?
Thanks for any input...
This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
Hi,
hmm... This is a simple measure, no calculation involved... Yes, there are a few relationships in the data model. But it just working fine with the right data type... I didn't fully understand your post but do you really think this linked to what you posted in your blog?
Thanks,
Thomas
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |