DAX FORMULA HELP

[Anonymous]

Hi Guys,

please help. I would like to create a measure wherein I will calculate the [ActualWorkingHoursMontly] * [DISTINCT # of EmployeeName]

Here's my sample dataset

[themistoklis]

@Anonymous

Can you try this formula.

Measure = SUM(TableName[ActualWorkingHoursMontly]) * DISTINCTCOUNT(TableName[EmployeeName])

[Anonymous]

I hope this works

SUM(TableName[ActualWorkingHoursMontly]) * COUNTROWS(SUMMARIZE(TableName,TableName[EmployeeName])

Good Luck!

[Anonymous]

Hi @Anonymous, thank you for helping me. but I didn't get the correct results.

See screenshot below. Thank you!

[v-danhe-msft]

Hi @Anonymous,

From your description, I could not understand the formula you have posted in below formula:

[DISTINCT # of EmployeeName], could you want to distintcount the EmployeeName? Could you please post your desired result if possible?

Regards,

Daniel He