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...
  • daXtreme's avatar
    daXtreme
    4 years ago
    [# Customers] =
sumx(
    summarize(
        T,
        T[date],
        T[customers for the day]
    ),
    T[customers for the day]
)
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!