Forum Discussion

Tito's avatar
Tito
Icon for Helper IV rankHelper 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
Tito's avatar
Tito
Icon for Helper IV rankHelper IV
2 years ago

Hi DataNinja777 ,

Thank you for your reply.
If I select name "A", 30 should be returned. 
I want the sum sales by maximum of date and not the maximum of sales.

  • DataNinja777's avatar
    DataNinja777
    Icon for Super User rankSuper User
    2 years ago

    Hi Tito 

    Sumxing over ID of the max sales measure will get your required output.  I am not sure why combining in one formula will produce the different result from separating out in two measures like below, but separating out in two measure will get your required output.

    Sumxing over ID = sumx(values('Table'[ID]),[Max sales])

    Best regards,

     

    • Tito's avatar
      Tito
      Icon for Helper IV rankHelper IV
      2 years ago

      Hi DataNinja777 ,

      Thank you very much! That worked too.

      Best regards