Measures on slicer

[Anonymous]

Hello, 

I have the following:

Problem: 

When using the date slicer it updates the black card visual correctly, but the white card visual doesn't give the correct corresponding value. It works fine for the Yesterday value but for no other dates in the slicer. 

The black card visual is calculating the latest figures using Measures:

Yesterday's Month to Date Total = [Measure 100]+[Measure 200]

Where:

Measure 100 =

CALCULATE([Total EOD Balance in GBP], FILTER(ALL('V3 Measure for Changes'),'V3 Measure for Changes'[rank]=max('V3 Measure for Changes'[rank])))

and 

Measure 200 =

  VAR __Max = MAX('V1 Measure Changes'[rank])

RETURN

  CALCULATE([Total Portfolio Balance in GBP], ALL('V1 Measure Changes'),'V1 Measure Changes'[rank]=__Max)

The white card visual is calculating the figures from the day prior to the Black cad visual, using the same dataset/calculation:

Two Days Ago Month to Date Total = [Measure 105]+[Measure 205]

Where:

Measure 105 =

CALCULATE([Total EOD Balance in GBP], FILTER(ALL('V3 Measure for Changes'),'V3 Measure for Changes'[rank]=max('V3 Measure for Changes'[rank])-1))

Measure 205 =

CALCULATE([Total Portfolio Balance in GBP], FILTER(ALL('V1 Measure Changes'),'V1 Measure Changes'[rank]=max('V1 Measure Changes'[rank])-1))

Thank you. 

Soo

[Greg_Deckler]

@Anonymous Maybe try this:

Measure 105 =
VAR __Max = MAXX(ALL('V3 Measure for Changes'),[rank])
RETURN
CALCULATE([Total EOD Balance in GBP], FILTER(ALL('V3 Measure for Changes'),'V3 Measure for Changes'[rank]=__Max-1))
 
Measure 205 =
VAR __Max = MAXX(ALL('V3 Measure for Changes'),[rank])
CALCULATE([Total Portfolio Balance in GBP], FILTER(ALL('V1 Measure Changes'),'V1 Measure Changes'[rank]=__Max-1))