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
