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.
Anyone know how to explain this? Why isn't my second column (Licensed Ha) summing the same way as the third column?
Hi. I've checked throughout the forum and I found this in another explanation:
Measure3 = SUMX(VALUES('Table1'[Tax Group]),IF([Measure1]>[Measure2],[Measure1],0))
So what I did is I created a measure, based on my column Licensed Ha 2, with the sumx formula. That is adding correctly.
The strange thing is that it is now causing the third column to be inaccurate. Which is really strange. Why does this happen?
hi, @Unicorn_Tech
It seems a measure total problem, here is a post for you refer to
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
If it is not your case, please share some data sample and formula of measure for us. Do mask sensitive data before uploading.
Best Regards,
Lin
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 |