Forum Discussion
Wrong total values
What is your goal here? If you want [Total Last Year] then do something like this:
Last Year = CALCULATE ( [Total X], SAMEPERIODLASTYEAR ( 'Dates'[Date] )
Then you can add this:
YTD Last Year = TOTALYTD ( [Last Year], 'Dates'[Date] )
Seems you are using a YTD measure as the basis of your [Last Year] measure
calculating the YTD or Last Year total isnt the issue.
my table contain multiple year / months, one item level the comparision of YTD and last year makes sense and the right difference between these two year get calculated. but on months level (total per months) it doesnt make sense anymore as.
for example: DATA 6 - if you sum everything up in the month March 2023 you get -8400, PowerBI is calculating -11900 what is wrong
Ah. OK. Is it something like [Quantity] x [Price]? If so, you need to calculate that at the individual LINE level, the create a measure to aggregate the sum.
You cannot aggregate the individula columns first and then do the multiplication or division.
5 pieces x $10 each = $50
10 pieces x $20 each = $200
From this you cannot say:
Total of 15 pieces x total of $30 each = $450.
You have to do the SUM of $50 + $200 = $250
Correct! Line would be -5 (Data 5) x 500 (Data 1) --> Result = Data 6 --> -2500
Aggregate should be Data 6 --> -8400 but right now i get -11900
How would that measure to aggregate the sum look like ?