Forum Discussion

datanau001's avatar
datanau001
Helper III
3 years ago

Measure for KPI indicator

Dear all,

 

I'm trying to create a KPI indicator with below dax code:

 

KPI Indicator Measure =
IF (
SUM( 'V_SR_STATUS_LINES_SEC'[Total Audit Time Hrs] ) < SUM( 'V_SR_STATUS_LINES_SEC'[AMT SLA] ),
"KPI Met",
"KPI Not Met"
)
 
However, it is not returning the expected result (see below image):
- on the left we have the columns to be compared "Time and SLA" and on the right when I put the measure "KPI Indicator Measure" it modifies the table where the time is then empty and everything is coming as "KPI not met".
 
I also tried it as a calculated column, but it won't work because in some SR numbers, I can have more than on line with different times and then it will create duplicates with both KPI Met and KPI not met, which would result in a wrong count of SR's.
 
So, I'd like to request your support on how I can fix this.
 
Thank you!
Datanaut
 
 
 
Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    datanau001 Try this:

    KPI Indicator Measure =
  SWITCH(TRUE(),
    SUM('V_SR_STATUS_LINES_SEC'[Total Audit Time Hrs]) = BLANK(),BLANK(),
    SUM( 'V_SR_STATUS_LINES_SEC'[Total Audit Time Hrs] ) < SUM( 'V_SR_STATUS_LINES_SEC'[AMT SLA] ),"KPI Met",
    "KPI Not Met"
)
    • datanau001's avatar
      datanau001
      Helper III
      3 years ago

      Greg_Deckler Hello Greg, thank you for your answer.

       

      It worked partially. See below, now in some cases the comparisson is not correct. 

      In first two lines, it should be KPI Not met

       

       

      Regards

      Marcelo