I am working on Recruitment Dashboard where i am displaying data in table and i want to display positions filled and open based on my date filter condition for which I created variable with below expression and i want to display it in KPI chat as No of positions filled for which i converted this expression into Master measure and try to find the count but its not working. Can you please help here
= if ( sum({1<[PosEmpty]={"1"},[Date requested]={"<=$(vSelectedMonth)"}>}Interval(vSelectedMonth-[Date requested],'DD'))>0, 'Open',if( SUM({1<[Date position filled]={">=$(vSelectedMonth)"},[Date requested]={"<=$(vSelectedMonth)"}>}Interval(vSelectedMonth-[Date requested],'DD'))>0, 'Open','Filled' ) )
