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
Hi All
I've got DAX measures that calculates the cumulative planned, actual and forecast. Using the planned and actual, I want to get a performance index on the programme report date so I used the dax measure in the image below. The table shows I'm getting the correct value however it does not appear on the card visual. Even with a report date filter, it does not show.
Is there another method of displaying that single value?
Solved! Go to Solution.
Hi @Larryten
Try creating separate measure for card visual using the following DAX:
Performance Index for Card =
VAR ReportDate = MAX('PlanningData'[ReportDate])
VAR PlannedValue = CALCULATE(
[Project Functional Planned],
'S Curve 01 Project Functionals'[TimephaseEnd] <= ReportDate
)
VAR ActualValue = CALCULATE(
[Project Functional Actual],
'S Curve 01 Project Functionals'[TimephaseEnd] <= ReportDate
)
RETURN
IF(
ISBLANK(PlannedValue) || PlannedValue = 0,
BLANK(),
DIVIDE(ActualValue, PlannedValue, 0)
)
Then use the [Report Date] field to create a slicer or page level filter.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Larryten
Try creating separate measure for card visual using the following DAX:
Performance Index for Card =
VAR ReportDate = MAX('PlanningData'[ReportDate])
VAR PlannedValue = CALCULATE(
[Project Functional Planned],
'S Curve 01 Project Functionals'[TimephaseEnd] <= ReportDate
)
VAR ActualValue = CALCULATE(
[Project Functional Actual],
'S Curve 01 Project Functionals'[TimephaseEnd] <= ReportDate
)
RETURN
IF(
ISBLANK(PlannedValue) || PlannedValue = 0,
BLANK(),
DIVIDE(ActualValue, PlannedValue, 0)
)
Then use the [Report Date] field to create a slicer or page level filter.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi @Larryten ,
according to your code, it doesn't show anything, because when there is no context, [PlannedValue] returns blank or zero.
hi @FreemanZ
so what I've done so far is this:
1) Calculate cumlative values via this code for planned, actual and forecast values:
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 |
---|---|
33 | |
15 | |
14 | |
12 | |
9 |