Forum Discussion

atul9063's avatar
atul9063
Helper III
7 years ago
Solved

Power KPI matrix error - KPI Indicator Index

Hi Team,   When i dragging [Calc KPI Index] Measure in KPI Indicator Index field, i m getting below error.   Below are measures formulas. Calc KPI Index = if(value([Calc Variance])>= .05, 1, if(...
General Comment
Interesting Links
Need Help
Show and Tell
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi atul9063

    Please Go to Edit Queries,

    Add a custom column 

     

    Then replace errors

     

    Close&&apply, re-write the measure using the "Custom" column instead of "co1", then Measure3 and Measure4 can be add to the visuals without any error.

     

    Best Regards

    maggie

     

atul9063's avatar
atul9063
Helper III
7 years ago

v-juanli-msftHi,

Thanks for reproducing this issue. I m using SQL Server Database and connectivity mode is import method.Please let me know how to solve this issue.Let me know any other information required.

Thanks

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi atul9063

Please Go to Edit Queries,

Add a custom column 

 

Then replace errors

 

Close&&apply, re-write the measure using the "Custom" column instead of "co1", then Measure3 and Measure4 can be add to the visuals without any error.

 

Best Regards

maggie