KPI activation based on filters

[deerio]

Hi to all, 

I have a KPI whose expression is an if condition that considers measures (not in the filters) greater than or equal to a given number. The expression returns Yes or No, as possible true or false.

In the KPI there is in the additional modules section, data management a function getSelectedCount([company])=1

In the filter pane I have 3 filters: company, month-year, and employee.

The KPI function is activated only when I select both a company, a month and an employee. If I select either one or two the field stays on the false condition, even though it should be on the true condition.

I need the kpi to give the exact condition even if two fields, company and month-year, are selected.

Thank you in advance.

[vinieme12 · Accepted solution]

Change condition to

=if( getSelectedCount([company]) and getSelectedCount([employee]) and getSelectedCount([month]),1,0)

Display message,

=if( getSelectedCount([company]) and getSelectedCount([employee]) and getSelectedCount([month]),'','Please Select')

&', ' &if( getSelectedCount([company]),'','company')

&', '&if(getSelectedCount([employee]),'','employee')

&', '&if(getSelectedCount([month]),'','month')