cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JeanWang
Helper V
Helper V

the positioning of userelationship

Hi, 

 

I try to calculate no. of employees left the organization within a certain period. 

I have written two measures, which I thought would generate the same results. However, only the first formula works properly. The 2nd measure always give huge numbers. Since in both measures, I have linked employee[Exit Date] with Calendar[Date], why the calendar filter didn't work in the second measure?

 

#leavers =

VAR Leavers =

CALCULATE (

COUNTROWS ( Headcount ),

NOT ISBLANK ( Headcount[Exit Date] ),USERELATIONSHIP ( 'Calendar'[Date], Headcount[Exit Date] )

)

RETURN

Leavers

 

 

#leavers 2 =

VAR Leavers =

CALCULATE (

COUNTROWS ( Headcount ),

NOT ISBLANK ( Headcount[Exit Date] )

)

VAR Leavers_filtered =

CALCULATE (

Leavers,

USERELATIONSHIP ( 'Calendar'[Date], Headcount[Exit Date] )

)

RETURN

Leavers_filtered

use relationship2.PNG

1 ACCEPTED SOLUTION
Jihwan_Kim
Community Champion
Community Champion

Hi, @JeanWang 

Please correct me if I wrongly understood your question.

In my opinion, in the second measure, Leavers in the first VAR is already defined. It means that the first VAR (Leavers) is a fixed-number in the whole-second measure.

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

1 REPLY 1
Jihwan_Kim
Community Champion
Community Champion

Hi, @JeanWang 

Please correct me if I wrongly understood your question.

In my opinion, in the second measure, Leavers in the first VAR is already defined. It means that the first VAR (Leavers) is a fixed-number in the whole-second measure.

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors