Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'.