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.

     

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.