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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.