Forum Discussion

Kebas_Leech's avatar
Kebas_Leech
Icon for Helper I rankHelper I
3 years ago
Solved

Summarize with ALL

Hello everyone,   I have the following function:     YEAR | MAX = VAR vals = SUMMARIZE( 'Date' , 'Date'[Year], "myMeasure", C...
  • Kebas_Leech's avatar
    Kebas_Leech
    3 years ago

    Solution was:

     

     

    VAR MaxValue = calculate([Prod | Max | AllY], ALL('Date'[Year]))
RETURN
    CALCULATE(
        MAX('Date'[Year]),
        FILTER(
            ALL('Date'[Year]),
            [Prod | Max | AllY] = MaxValue
        )
    )

     

     

Kebas_Leech's avatar
Kebas_Leech
Icon for Helper I rankHelper I
3 years ago

Solution was:

 

 

VAR MaxValue = calculate([Prod | Max | AllY], ALL('Date'[Year]))
RETURN
    CALCULATE(
        MAX('Date'[Year]),
        FILTER(
            ALL('Date'[Year]),
            [Prod | Max | AllY] = MaxValue
        )
    )