Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Help in create Max measure for aggregate value.

I am struggling in creating a dax measure to calculate max unit quantity sold base on column in table visual. I just create a simple measure "Max = Max(table[Total sold]) "and it seem ok in 1s...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,
    try the following formula.

    MeasureMax = CALCULATE(SUM('Table'[Total Sold]), ALLEXCEPT('Table','Table'[day]))

    Drag the measuer into the table visual and the result is shown below.

    If the above ones can’t help you get it working, could you please provide the expected result to make a deep troubleshooting? It would be helpful to find out the solution.

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Zang_Mi's avatar
Zang_Mi
Resolver II
2 years ago

Hello, it is normal that the measure returns different maximum values since the aggregattion has been done with different granularity levels. More information is needed to solve your problem, for example, a complete sample data for a specific date, with raw data, and the expected aggregation result with and without restaurant_code.

Regards