Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
93 | |
90 | |
35 | |
35 |
User | Count |
---|---|
154 | |
102 | |
82 | |
64 | |
54 |