Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
titine38300bj
New Member

averagex and total doesn't work

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

1 ACCEPTED SOLUTION
sjoerdvn
Super User
Super User

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. 

View solution in original post

1 REPLY 1
sjoerdvn
Super User
Super User

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. 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors