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 All,
A DASHBORD provides information on Total Demand by Report's Months. There are several reports staked one over the other, and to compare demand differences of a past month report to current month report we use DAX. DAX aggregates SUMs filtered by report Month. So that Demand Curr (Month 0) is 192M and Demand Qty M-1 (Month -1, Last Column) is 201M.
The two months show a difference of ~9.7Millions (at the bottom) under the col Delta.
To verify that the sum was correct, I exported the same underlying data to an excel file:
It seems that DAX has some difficulties with filtered high volume data; though it is weird that it does it well in the first month, but not for the second...
Details on the DAX formulae:
DAX:
Month of the report:
[REPORT_MONTH]: contains months 0,-1,-2,-3, etc. and records are tied to a date row/col.
Month0:
Hi @Anonymous ,
Without sample data, I think it's hard to figure out what the problem is.
I think you can try to remove most of dimensions, just keep the dimension which only have few values, then you will find why the total is different than sum of every rows.
If not, you may need to track the details I think.
Thanks.
Aiolos Zhao
Proud to be a Super User!
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |