Measure value is not dynamic when inserted into a table

[OsmanEmi]

Hi All,

I'm trying to create a scoring system for my table with a measure however whenever i insert the measure into the table I get just 1 value for all as opposed to it being dynamic for all rows. Can someone explain the logic behind it and what I'm missing?
Table and measure below, please note the -IN FULL (KPI) the measures refers too is also a measure and total value is 99.

1OIn Full Score =

var OnTimeScore = 0

Return

IF(-FACT_TRACKING_PERFORMANCE_UKIE[-IN FULL (KPI)] > 0.98, OnTimeScore + 0, OnTimeScore + 1)

Restaurant	KPI	Score
1	98%	1
2	90%	1
3	94%	1
4	99%	1

[Ashish_Mathur · Accepted solution]

Hi,

Remove the minus sign after the (.

[Anonymous]

@OsmanEmi 

This should not happened, what is the formulas for measure -IN FULL (KPI)?

Paul Zheng _ Community Support Team