Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
I want to calculate an annual smoothed average and I notice that the total of this MLA does not add up > 2 measures DAX
ED = SUM('Restitution'[ED])
end
MLA =
CALCULATE(
AVERAGEX(
VALUES(Calendrier[Mois]),
[ED]
),
DATESYTD(Calendrier[Date])
)
Team | MLA |
A | 29,81 |
B | 21,30 |
C | 43,64 |
D | 22,49 |
E | 43,33 |
F |
|
G | 163,59 |
H | 254,36 |
calcul OK --> I would like this | 578,51 |
|
|
calcul KO ( Power BI) | 569,38 |
Solved! Go to Solution.
For the AVERAGEX to make sense, I would expect a table expression in there related to the "Team", now it seems to be about dates; but there is not enough information on your model and the visual to help with the actual DAX measures.
For the AVERAGEX to make sense, I would expect a table expression in there related to the "Team", now it seems to be about dates; but there is not enough information on your model and the visual to help with the actual DAX measures.