KPI incorrectly gives over 100%

Hi o59393 ,

I have checked your PBI file, that's because you have duplicated values for some IDs, so you can't only use SUM to calculate the KPI.

Please try to use below measure to instead of:

Q/FS Total DAX = 
var _ingredients = 
(
SUM('Suppliers Compliance'[Audit Score (25%)])/ COUNT('Suppliers Compliance'[Id]) + 
SUM('Suppliers Compliance'[CAP Score (5%)])/ COUNT('Suppliers Compliance'[Id]) + 
SUM('Suppliers Compliance'[QF Score (20% Ing/ 30% pack)])/ COUNT('Suppliers Compliance'[Id]) + 
SUM('Suppliers Compliance'[Score Threats (10%)])/ COUNT('Suppliers Compliance'[Id]) + 
SUM('Suppliers Compliance'[Score Analysis (10%)])/ COUNT('Suppliers Compliance'[Id])
)
/
70
var _package = 
(
SUM('Suppliers Compliance'[Audit Score (25%)])/ COUNT('Suppliers Compliance'[Id]) + 
SUM('Suppliers Compliance'[CAP Score (5%)]) / COUNT('Suppliers Compliance'[Id])+ 
SUM('Suppliers Compliance'[QF Score (20% Ing/ 30% pack)]) / COUNT('Suppliers Compliance'[Id])+ 
SUM('Suppliers Compliance'[Score Threats (10%)])/ COUNT('Suppliers Compliance'[Id]) 
)
/
70
return
IF(SELECTEDVALUE ('Suppliers Compliance'[Type])  = "Ingredients" , _ingredients  , _package)

Aiolos Zhao