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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
ase
Frequent Visitor

Wrong aggregation measure dax

Good afternoon, 

 

I have a problem with the aggregation of a measure. 

 

Below is an illustration of my data:

ase_0-1664454778677.png

 

Because of the "type of product" column, when I use SUMX for the customers for the day, I get the following:

ase_1-1664454840262.png

 

What I wish to achieve is this result: 

ase_2-1664454868364.png

 

I tried using AVERAGEX and it works correct, when I view it for a particular day, but when I try to see the oranges for the month, it does not show the correct answer.

 

Could anyone please help me with this dax? 

 

Thank you very much in advance!

 

 

 

1 ACCEPTED SOLUTION
daXtreme
Solution Sage
Solution Sage

[# Customers] =
sumx(
    summarize(
        T,
        T[date],
        T[customers for the day]
    ),
    T[customers for the day]
)

View solution in original post

2 REPLIES 2
daXtreme
Solution Sage
Solution Sage

[# Customers] =
sumx(
    summarize(
        T,
        T[date],
        T[customers for the day]
    ),
    T[customers for the day]
)
ase
Frequent Visitor

Thank you very much for the help!

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 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.