Forum Discussion

atiyah's avatar
atiyah
Regular Visitor
8 years ago

Sum the total KPI

Hi,

 

Does anyone know how to solve 2 of my problems when I'm using KPI Indicator:

1- The trend axis doesn't shows the monthly trend (Jan-Mar).

Jan=no data; Feb & Mar= had data. The trend only start from Feb onward. 

2- The Actual Value shows 2 if I include the trend axis. But I want it to shows the total value (which is 3) when I'm Include the trend axis. 

I'm using formula: Actual 2018 = COUNTAX(FILTER(Details,Details[Year]=2018),Details[Year])

 


    

 

 

Regards,

Atiyah

Need Help
Show and Tell

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi atiyah

    the trend axis doesn't show the blank value, a workaound is to set the blank to 0.

    the actual value in KPI shows the value for the last item in the trend axis, try this formalu to get total value

    Actual 20181 =
CALCULATE ( COUNTROWS ( Details ), ALL ( Details ) )

    Best regards

    Maggie

    • atiyah's avatar
      atiyah
      Regular Visitor
      8 years ago

      Hi v-juanli-msft,

       

      Thank you so much for the reply. 

      Really appreciate it.

      I tried your formula, the new problem raise where the value is invalid. 

      The line still didn't show the trend from Jan-Mar. 

      Formula: Actual 2018v1 = CALCULATE(COUNTROWS(Details), ALL('Details'))

       

           

       

      Kind regards,

      Atiyah