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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.