Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measures on slicer

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
Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    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))