Forum Discussion

OsmanEmi's avatar
OsmanEmi
Frequent Visitor
5 years ago
Solved

Measure value is not dynamic when inserted into a table

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)
 
RestaurantKPIScore
198%1
290%1
394%1
499%1

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    OsmanEmi 

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

     

     

    Paul Zheng _ Community Support Team