Forum Discussion

SACooper's avatar
SACooper
Icon for Helper II rankHelper II
4 years ago
Solved

Performance Against Target Measure giving weird results within Matrix

  The measure is as follows:   VAR _daysInView = COUNTROWS(VALUES(CIVICA_CompletedItems[ProcessedDate])) VAR _numberOfStaff = COUNTROWS(VALUES(CIVICA_CompletedItems[ProcessedBy])) -- VAR...
Need Help
  • Luuky's avatar
    Luuky
    4 years ago

    Hi SACooper, 

    What i mean is for example

    KP = (1908-1685)/1685

    LW = (494-820)/820

    MW = (1090-1572)/1572

    This should give the value I assume you are looking for.

    Greetings,

    Luuk

Luuky's avatar
Luuky
Icon for Helper I rankHelper I
4 years ago

Hi SACooper,

Its indeed pretty wierd that is does this. So if I understand correctly the output is not 0 without the -1?

If that is the case can you show the output % that is shown. 

What you can also try is add a measure with value 1 and change the type to %, then make another measure that substracts the newly made measure from _performanceAgainstTargetPercentage and look at all the values in a table and check what it does. 

This is what it does for me:

 

Greetings, 

Luuk

 

  • SACooper's avatar
    SACooper
    Icon for Helper II rankHelper II
    4 years ago

     

     

    This is what is happens when I return _performanceAgainstTargetPercentage. So as you can see I was expecting figures such as  102.86% (1.02), -24.12% (-0.24) etc. after subtracting 1

     

    ** Please ignore the infinity references there are to be expected as the underlying data for that time period has yet to be captured..

    • Luuky's avatar
      Luuky
      Icon for Helper I rankHelper I
      4 years ago

      Hi SACooper,

      What you can do is instead of doing -1 you can do - _target. In this scenario 100% = the target. Also use Divide() to divide. Hope this helps!

      Greetings, 

      Luuk

      • SACooper's avatar
        SACooper
        Icon for Helper II rankHelper II
        4 years ago

        Hi Luuky 

         

        in this case _Target is not 100% its a calculated numerical value. From the example above for week 25/07/2022

         

        KP = 1908 / 1685

        LW = 494 / 820

        MW = 1090 / 1572

         

        so if I take _Target away I get an extremly large number.

         

        Thank you for the DIVIDE function reminder i've replaced that element.