Measures

[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

[v-stephen-msft]

Hi @Anonymous ,

Sorry, not very clear.

Can you provide some virtual data and the desired results?

And what is the [rank] for?

You have the text 'Yesterday' in the slicer field, so your dates are also in text format, hope you know that.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.