Max of a measure

[Anonymous]

Hi everyone,

I have a measure, called Revenue. This measure is as follows:

VAR maandselectie =

    SUM ( 'Maand selectie'[Index maand] )

VAR jaarselectie =

    SUM ( 'Maand selectie'[Index jaar] )

RETURN

    CALCULATE (

        SUM(Verkoopfacturen[Bedrag]),

        Datumtabel[Index maand] <= maandselectie,

        Datumtabel[Index jaar] = jaarselectie

    )

This is the outcome of that measure. 

I want to have a new measure, which returns for all months the highest result of Revenue, so 1.646.498. I tried many things already, like RemoveFilters, All, AllExcept, but I can't figure it out. Can someone help me with this? 
Thanks in advance!

[MFelix · Accepted solution]

Hi @Anonymous ,

For this you need to use a iterator formula something similar to:

Revenue MAX = MAXX(VALUES(Table[MonthYear]), [Revenue])

This should return the expected result.

[Anonymous]

@MFelix This is what I needed!!