Forum Discussion

Larryten's avatar
Larryten
Frequent Visitor
1 year ago
Solved

Card Visual not showing value

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 th...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

FreemanZ's avatar
FreemanZ
Super User
1 year ago

hi Larryten ,

 

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

  • Larryten's avatar
    Larryten
    Frequent Visitor
    1 year ago

    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?