Forum Discussion
Question for PowerBI Masters: wrong year totals
- 7 years ago
Hi all, solved the problem! I am sharing it as it coud be useful to someone else.
This was the original formula, with correct values on daily rows, wrong on total year:
RMS = SUMX(SUMMARIZE(VALUES('Calendar'[Day]);[Day];"ABCD";IF([maxreadingdate]<[maxdata];[OTB];[RMS DW]));[ABCD])
This is the correct formula:
RMS = SUMX(SUMMARIZE(VALUES('Calendar'[DATE].[Date];[DATE].[Date];"ABCD";IF([maxreadingdate]<[maxdata];[OTB];[RMS DW]));[ABCD])
The error was pointing the the "day" dimension 'Calendar'[Day] instead than to the "full date" dimension 'Calendar'[DATE].[Date]
Pointing to 'Calendar'[DATE].[Date] also the total of the year is correct.
Hi all, solved the problem! I am sharing it as it coud be useful to someone else.
This was the original formula, with correct values on daily rows, wrong on total year:
RMS = SUMX(SUMMARIZE(VALUES('Calendar'[Day]);[Day];"ABCD";IF([maxreadingdate]<[maxdata];[OTB];[RMS DW]));[ABCD])
This is the correct formula:
RMS = SUMX(SUMMARIZE(VALUES('Calendar'[DATE].[Date];[DATE].[Date];"ABCD";IF([maxreadingdate]<[maxdata];[OTB];[RMS DW]));[ABCD])
The error was pointing the the "day" dimension 'Calendar'[Day] instead than to the "full date" dimension 'Calendar'[DATE].[Date]
Pointing to 'Calendar'[DATE].[Date] also the total of the year is correct.