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 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?

  • 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.

     

3 Replies

  • 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?
       
       



  • Anonymous's avatar
    Anonymous
    Not applicable
    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.