Forum Discussion

ibrewop23's avatar
ibrewop23
Frequent Visitor
3 years ago

USERELATIONSHIP usage: One active and one inactive relationship in calculate measure

Hi - I am looking to understand if I need to be using 'USERELATIONSHIP' in my measure and if not, why not?   I am calcualting headcount as at the end of each calendar month. Here is my model: ...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

ibrewop23 , Try like

 

Headcount End of Month =
CALCULATE (
Countx(Filter( 'Headcount',
'Headcount'[Start Date] <= MAX ( 'Date Table'[End of Month] )
&& (
Headcount[Leave Date] > MAX ( 'Date Table'[End of Month] )
|| ISBLANK ( Headcount[Leave Date] )
)
),'Headcount'[Employee Code] ), crossfilter('Date Table'[Date],'Headcount'[Leave Date], none) )

 

 

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

ibrewop23's avatar
ibrewop23
Frequent Visitor
3 years ago

thanks! appreciate you wrting back. 

 

Maybe I should have been clearer but I am looking to find out is an answer to this question specifically: 

 

I am looking to understand if I need to be using 'USERELATIONSHIP' in my measure and if not, why not?