Monthly Overtime instead of overall sum total

[rosscortb]

Hello, I am creating an employee page that shows the last position, last location etc.

On the same page I want to have the employees monthly Overtime but everytime it just shows the total overall overtime instead of that employee I selected in the filter. Any Ideas? Ross

Do I need a measure?

[Anonymous]

try this measure. I can't be 100% certain this will do what you need without a sample dataset.

Assumes that Month is abbreviated month name i.e. JAN/FEB/MAR rather than full name or number.

If full name then change "MMM" to "MMMM"

For month number change FORMAT(TODAY(),"MMM") to MONTH(TODAY())

Assumes that you are selecting a specific employee number from a slicer

=CALCULATE(
	SUM('DB Overtime Master'[Total]),
	FILTER('DB Overtime Master',
		'DB Overtime Master'[Month] = FORMAT(TODAY(),"MMM")
		&& 'DB Overtime Master'[Year] = YEAR(TODAY())
		&& RELATED('DB Headcount'[Name]) = SELECTEDVALUE('DB Headcount'[Name])
	)
)

[PattemManohar]

@rosscortb Please provide the sample data in copiable format to suggest any solution.