I have a problem with making filtered KPI expression. The formula below doesn't work.
[Recognition Date: # Distinct recognitionHashKey] WHERE [Fiscal Time.Calendar Year] = GetVariable( 'Current Calendar Year' )
AND IIF( 'V{USER_GROUP_LIST}' = 'Admin' OR 'V{USER_GROUP_LIST}' = 'Power User' OR POSITION('V{USER}', [Manager Security Recognized By.ManagerEmailLookUp]) >= 0, 1, 0) = 1
We can't set this filter (IIF condition) to whole dashboard, it is not possible since [Manager Security Recognized By] is an inherited source. This filter is applied inside each visualization except KPI now.
How can I make this expression work? Or is there other way to achieve this goal?
Thank you in advance