Forum Discussion

Tito's avatar
Tito
Helper IV
2 years ago
Solved

Calculate Sum MAX

Hello everyone, Can someone please help me how to calculate the maximum of Sales. See the data below: Data:  Result: Best regards Tito
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Hi Tito,

    Please try this formula:

    MAX Measure = 

VAR _Table =
     ADDCOLUMNS(
        SUMMARIZE(
            T_MaxQ,
            T_MaxQ[Name],
            T_MaxQ[ID]
        ),
        "@MaxSales",   
		VAR _MAX = CALCULATE(MAX(T_MaxQ[Date]))
		VAR _Result = 
			CALCULATE(
				SUM(T_MaxQ[Sales]),
				T_MaxQ[Date] = _MAX
				
			)
		RETURN
			_Result
    )
VAR _Result = SUMX(_Table, [@MaxSales])
RETURN
    _Result
Ajithkumar_03's avatar
Ajithkumar_03
Frequent Visitor
2 years ago

Hi Tito 

please refer the below measures.

Sample Table:


Measure 1:

 

Measure 2:


Result:

 



I hope this measure will help you.

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Best Regards,
Ajith Kumar

  • Tito's avatar
    Tito
    Helper IV
    2 years ago

    Hi Ajithkumar_03 

    Thank you very much! That worked too. 👍

    Best regards