Variable Correct before going in table, but wrong in each row

thefish — Tue, 21 Dec 2021 20:15:22 GMT

I am designing a control table for my company and coming acorss an odd issue.

The table has the following structure:

1 dimension (we'll call it [Group])

A couple of measures most of which are master measures and 1 new measure (Days out of control)

The days out of control measure works fine if not in the table and is in a KPI (It shows the number of days beneath the LCL)

However, when we move it into the table, I hit an odd error. the value of this days out of control is an error.

The expression is listed below (modified to hide company data)

SUM(AGGR(IF($(vValue)<$(vLowerLimit),1,0), [Date]))

I have tried fixing my = signs in variables to find the solution but to no avail.

Please help!

Thanks in advance,

Fish

topic Variable Correct before going in table, but wrong in each row in App Development