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. I...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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))