Forum Discussion

tbucki1's avatar
tbucki1
Icon for Advocate I rankAdvocate I
9 years ago
Solved

KPI card displays incorrect value

I just created a KPI card that shows Actuals Vs Budget for a given time period... Both Actuals and Budget are DAX equations. I bring Actuals into the "indicatior" section, Budget to "Target Section"...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi tbucki1,

     

    To display cumulative totals for Actual and Budget in KPI visual based on checked month from the slicer, you can create two measures to return cumulative total:

     

    RunningAcrual = CALCULATE(SUM(Table2[Actual]),FILTER(ALL(Table2[Month]),'Table2'[Month]<=MAX('Table2'[Month])))

    RunningBudget = CALCULATE(SUM(Table2[Budget]),FILTER(ALL(Table2[Month]),'Table2'[Month]<=MAX('Table2'[Month])))

     

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi tbucki1,

 

To display cumulative totals for Actual and Budget in KPI visual based on checked month from the slicer, you can create two measures to return cumulative total:

 

RunningAcrual = CALCULATE(SUM(Table2[Actual]),FILTER(ALL(Table2[Month]),'Table2'[Month]<=MAX('Table2'[Month])))

RunningBudget = CALCULATE(SUM(Table2[Budget]),FILTER(ALL(Table2[Month]),'Table2'[Month]<=MAX('Table2'[Month])))

 

 

 

Best Regards,
Qiuyun Yu

marta_spg's avatar
marta_spg
New Member
8 years ago

Hi @Qiuyun Yu,

 

I am facing exactly the same problem, but the solution you propose does work for the KPI but then not for the trend value (the line), as it give cummulative evolution view.

 

When you have daily information, there's really no point in looking at the last day, it would be much better to analyze for example last month (or YTD), and in the trend axis maintain the daily evolution.