line chart showing different values than dax

[zuziak88]

Hi,

I have issue with line chart. I would like to show how many leavers and new joiners we had in 2018-2023. When I use dax to calculate it is showing proper values. However line chart is showing different values for leavers -- 596(ok) vs 169(not ok) in 2023. Would appreciate your help.

Many thankshttps://www.dropbox.com/scl/fi/zs5v0migkpeolms11l8lc/Exercise.pbix?rlkey=lhmz1dkf2wokqetvjyjjlztyi&s... 

[Fowmy · Accepted solution]

@zuziak88 

You have two different date columns in your fact table, start and end dates, I created an inactive relationship from Date[Date] to TrainingTable[Exit Date] and the following meaures :

Leavers 1 = 
CALCULATE(
    DISTINCTCOUNT( Employee_Training_Table[empid] ),
    USERELATIONSHIP( 'Date'[Date] , Employee_Training_Table[exitdate] )
)

New Joiners 1 = 
    DISTINCTCOUNT( Employee_Training_Table[empid] )

File attached, you may use these measure where necessary