Forum Discussion

ase's avatar
ase
Frequent Visitor
4 years ago
Solved

Wrong aggregation measure dax

Good afternoon, 

 

I have a problem with the aggregation of a measure. 

 

Below is an illustration of my data:

 

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

 

What I wish to achieve is this result: 

 

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!

 

 

 

  • daXtreme's avatar
    daXtreme
    4 years ago
    [# Customers] =
sumx(
    summarize(
        T,
        T[date],
        T[customers for the day]
    ),
    T[customers for the day]
)

2 Replies

  • daXtreme's avatar
    daXtreme
    Icon for Solution Sage rankSolution Sage
    4 years ago
    [# Customers] =
sumx(
    summarize(
        T,
        T[date],
        T[customers for the day]
    ),
    T[customers for the day]
)
    • ase's avatar
      ase
      Frequent Visitor
      4 years ago

      Thank you very much for the help!