Forum Discussion

ChrisWeeks92's avatar
ChrisWeeks92
Icon for Helper I rankHelper I
8 years ago

DAX Measure to acheive target KPI

The company i work for have a client which gets audited on 5 different sites every day. The client has a KPI of 95% for each site which they need to acheive at month end. If they do not acheive the t...
Need Help
  • ChrisWeeks92's avatar
    ChrisWeeks92
    Icon for Helper I rankHelper I
    8 years ago

    hi Anonymous

     

    Apologies, sample data would be on my google drive:  Demo Data

     

    Hopefully it all makes sense,  basically i need a formula/way to find out what score is needed to acheive the KPI score for each site.  The KPI for the site is 95%. The site needs to reach 95% average by the end of the month.  

     

    Essentially i need a Card visual showing the score needed to acheive the 95% KPI target?

     

    Any help is greatly appreciated.  

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi ChrisWeeks92,

       

      You can try to use below formula measure to get rolling average group by year month.

      Rolling AVG =
VAR currDate =
    MAX ( Sheet1[Date/Time] )
RETURN
    CALCULATE (
        AVERAGE ( Sheet1[TotalScore] ),
        FILTER (
            ALLSELECTED ( Sheet1 ),
            Sheet1[Date/Time] <= currDate
                && FORMAT ( [Date/Time], "mm/yyyy" ) = FORMAT ( currDate, "mm/yyyy" )
        ),
        VALUES ( Sheet1[Username] ),
        VALUES ( Sheet1[Site] )
    )

       

      Card visual not suitable for your requirement, please use multi-row card to instead.

       

      Regards,

      Xiaoxin Sheng