Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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:
Where:
The white card visual is calculating the figures from the day prior to the Black cad visual, using the same dataset/calculation:
Where:
@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))
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
68 | |
25 | |
18 | |
12 |