join clause within a master item measure

[#1]

Hi All

Is it possible to have inner join created while defining master items..

e.g. I am trying to define something like this within the expression of a master item measure:

Count(distinct (Employee.[EmpID-EmployeeID] inner join Order.[EmpID-EmployeeID]))

Is it too outrageous??

[devarasu07]

Hi,

yes we can do that, in the back end script try to use exists function and also we can use inner join. would be able to share your mock data and expected output here. thanks

Regards,

Deva