Hi All,
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'
)
)
Thanks
Rajesh
