Incorrect Total in Matrix - Trying to Produce Average in the Total
Thank you in advance for the help, so I have the below DAX measure that is technically producing the correct values for each month, however my total is incorrect. I want my total to produce the average of all the months in 2023 below. So the correct average would be $18.65 instead of $26.58 (per below screenshot). How can I change my measure to do this? I believe I need an AVERAGEX or a HASONEVALUE function, but not sure about the proper syntax. WTI - WCS Diff ($US/bbl) - Hardisty = VAR LastDayWithPrice = CALCULATE( LASTNONBLANKVALUE(Data[PriceDate], MAX(Data[PriceDate])), Data[symbol]="#DG.MO_INDEX.WCS_HRD/CURVE/M00") VAR Price = CALCULATE( [Average Close], Data[PriceDate]=LastDayWithPrice, Data[symbol]="#DG.MO_INDEX.WCS_HRD/CURVE/M00") RETURN ABS(Price) Matrix Visual (total is incorrect, monthly values are correct). I want the total to be an average of the monthly values. Fields in Matrix:
Trying to get total sum of measure correctly
Hi, I need help in getting the correct values for the sum of a measure, the total showing wrongly. I have a measure that calculates the cost of consumption of electricity readings, the dax formula for cost is: Electricity = IF('Table'[Consumption]>10000,(('Table'[Consumption]-10000)*0.22+(6000*0.17)+(4000*0.13)),(IF('Table'[Consumption]<4000,('Table'[Consumption]*0.13),((4000*0.13)+('Table'[Consumption]*0.17))))) The Total should be 40308 When i tried to sum the measure using SUMX('Table','Table'[Electricty]) I tried to search online but couldn't; find a solution
