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
_AAndrade's avatar
_AAndrade
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi Tito,

Here is my solution:

I'm using this measure:

 

MAX Measure = 
VAR _Table =
    ADDCOLUMNS(
        SUMMARIZE(
            T_MaxQ,
            T_MaxQ[Name],
            T_MaxQ[ID]
        ),
        "@Max", CALCULATE(MAX(T_MaxQ[Sales]))
    )
VAR _Result = SUMX(_Table, [@Max])
RETURN
    _Result

 

 

 

And the final result is this:

 

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

    Hi _AAndrade  DataNinja777 
    Thank you for your reply.
    I want the sum sales by maximum of date and not the maximum of sales. See example below:

    Data:


    Result:

     

     

    • _AAndrade's avatar
      _AAndrade
      Icon for Resident Rockstar rankResident Rockstar
      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 _AAndrade 

        Thank you very much! It worked really well.

        Best regards