Receiving NaN value on KPI - Set Analysis

[RWilliams92]

I'm struggling to get my KPI value to display correctly (displays NaN as the value).

I'm wanting to have 2x KPI's - the 1st one is just averaging a single column from one of my tables (=AVG([Price]). This is displaying correctly.

The second one I want to display the average from that same column, IF a string matches from another column (CSS is equal to Active. My current formula for this is: =Avg({<[CSS]={'Active'}>}[Price])

Could anyone help me to solve this issue? I've looked at other examples and I think my syntax is correct but please correct me if i'm wrong!

Thanks in advance

[Gysbert_Wassenaar]

The syntax is ok. Make sure you're using the exact case sensitive field names and field values. CSS is not Css and 'Active' is not 'active'.