Result Set is not getting properly in if condition
Hi Community,
I Have one variable named as 'v_PortfolioManagerId'... I want to use this variable for filter pane so that i have created measure like this : if(PortfolioManagerId=v_PortfolioManagerId, CycleID)
Now I want add one more condition for this filter 'if(GetFieldSelections(PortfolioManager)<>null()' it should show all cycledID's otherwise it should show this condition cycleid's only if(PortfolioManagerId=v_PortfolioManagerId, CycleID)
I tried these two expressions but i am not getting the result set properly.... Can you guys please check and let me know what i missed. Itried all these Expressions
if(PortfolioManagerId<>v_PortfolioManagerId and GetFieldSelections(PortfolioManager)<>null(), CycleID,if(PortfolioManagerId=v_PortfolioManagerId, CycleID))