topic Re: Card Visual not showing value in DAX Commands and Tips

Card Visual not showing value

Larryten — Thu, 31 Oct 2024 12:36:58 GMT

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?

Re: Card Visual not showing value

FreemanZ — Thu, 31 Oct 2024 14:35:41 GMT

hi Larryten ,

according to your code, it doesn't show anything, because when there is no context, [PlannedValue] returns blank or zero.

Re: Card Visual not showing value

Larryten — Thu, 31 Oct 2024 14:44:57 GMT

hi FreemanZ
so what I've done so far is this:
1) Calculate cumlative values via this code for planned, actual and forecast values:

Project Functional Planned = CALCULATE(SUM('S Curve 01 Project Functionals'[PlannedDurationHours]),FILTER(ALLSELECTED('S Curve 01 Project Functionals'),'S Curve 01 Project Functionals'[TimephaseEnd]<=MAX('S Curve 01 Project Functionals'[TimephaseEnd])))

2)Filter the value for the report date:

Project Functional Planned on Report Date =

VAR ReportDate = MAX('PlanningData'[ReportDate]) -- Obtain the selected Report Date

RETURN

IF(

MAX('S Curve 01 Project Functionals'[TimephaseEnd]) = ReportDate,

[Project Functional Planned],

BLANK()

)

The table shows the values as expected.
What I want to do is calculate the perfomance index (Actual/planned) based the output value in 2).
How would I got about this and allow it to show the dynamic value in a card visual?

Re: Card Visual not showing value

Anonymous — Mon, 04 Nov 2024 02:15:46 GMT

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.