Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have a couple of KPIs and I want them to not show anything unless a particular dimension is selected.
Here's a image of my dashboard:
I want the KPIs in red to only display values if there's an employee or more selected. How do I do this?
I tried putting GetFieldSelection(Employee) and GetFieldSelection(Employee) = Employee on the Calculation Condition in the Data Handling section, but it doesn't work.
How can I achieve this?
Thank you in advance.
Try using this in the KPI measure expression:
=if(GetFieldSelections([Employee])>0,count(Course),'')
Try using this in the KPI measure expression:
=if(GetFieldSelections([Employee])>0,count(Course),'')
It worked. Thank you 🙂