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