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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Based on my testing, the max function is no problem. When drag the restaurant_code into the table visual, the Max measure will be maximized by a different code. So the result is shown in the first picture.

When removing the restaurant_code column, Total sold will automatically aggregated. So the Max measure will calculate the max value based on the day.

 

please try the following methods:

1.Create the sample table.

2.Create the measure to calculate MAX.

MeasureMax = MAXX(VALUES('Table'[restaurant_code]), CALCULATE(MAX('Table'[Total Sold])))

 

3.If remove the restaurant_code column from the table visual. The result is shown below.

 

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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

What I want is the measure should show the max of accumulate quantities sold in each day. In your example, if you put Total Sold column in 3rd table, the max should show 109 (sum of 24-Mar-24).

Btw, thank you for your help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.