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

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.

Luuky's avatar
Luuky
Icon for Helper I rankHelper I
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