How to sort filters in calculate

[luizahenriques]

Hello everyone!

I need to put the last value of "Média Móvel" measure in another measure called "Forecast". I got it but i wont't like to see this valuye "78.116,71" in past months. I'd like to see only in the forecast months(since 2022-novembro).

Measure

-----

Forecast =

VAR ultimoDiaComValor = CALCULATE(MAX('fDados Gerais dos Contratos SAMC'[Data Fim]),ALL('fDados Gerais dos Contratos SAMC'))

RETURN  

CALCULATE(Medidas[Média Móvel],FILTER(ALLSELECTED('dCalendário'[Date]),'dCalendário'[Date]=ultimoDiaComValor))

------

Can someone help me?

[MFelix · Accepted solution]

Hi @luizahenriques ,

Try to change your metric to:

Forecast =
VAR ultimoDiaComValor =
    CALCULATE (
        MAX ( 'fDados Gerais dos Contratos SAMC'[Data Fim] ),
        ALL ( 'fDados Gerais dos Contratos SAMC' )
    )
RETURN
    IF (
        MAX ( 'dCalendário'[Date] ) > EOMONTH ( ultimoDiaComValor, 0 ),
        CALCULATE (
            Medidas[Média Móvel],
            FILTER (
                ALLSELECTED ( 'dCalendário'[Date] ),
                'dCalendário'[Date] = ultimoDiaComValor
            )
        )
    )

This will compare the maximum date on that specific line with the value of the end of month your last contratos if it's higher then it will retun the value if not it will be blank.