PBI measure to only divide the last available date

[mra1984]

I want to divide the last month's data but I can't use last month as sometimes we are not able to update for a few months. I came up with this which doesn't work: Partipation_value_month = FILTER(raw,max(raw[Date]) RETURN DIVIDE( CALCULATE(SUM(raw[Value]),raw[Online/TE]="Online"), CALCULATE(SUM(raw[Value]),raw[Online/TE]="TE")) The bit after DIVIDE works for what I want but I don't know how to filter for the last month's read max(raw[Date) works on it's own but how to integrate into this existing measure? Thanks

[v-eachen-msft]

Hi @mra1984 ,

You need to put filter in the calculate query. You could try this DAX:

DIVIDE (
    CALCULATE (
        SUM ( raw[Value] ),
        raw[Online/TE] = "Online",
        FILTER ( raw, MAX ( raw[Date] ) )
    ),
    CALCULATE (
        SUM ( raw[Value] ),
        raw[Online/TE] = "TE",
        FILTER ( raw, MAX ( raw[Date] ) )
    )
)

Or

A =
VAR a =
    FILTER ( raw, MAX ( raw[Date] ) )
RETURN
    DIVIDE (
        CALCULATE ( SUM ( raw[Value] ), raw[Online/TE] = "Online", a ),
        CALCULATE ( SUM ( raw[Value] ), raw[Online/TE] = "TE", a )
    )

[mra1984]

The formula is accepted but nothing is actually being filtered for some reason 

[mra1984]

Basically I want this measure but for the last month only (via max date) only:

DIVIDE(

CALCULATE(SUM(raw[Value]),raw[Online/TE]="Online"),

CALCULATE(SUM(raw[Value]),raw[Online/TE]="TE")) 

A whole page date filter ruins other measures.  Thanks