Reply
Highlighted
Regular Visitor
Posts: 44
Registered: ‎06-29-2016

DAX FORMULA HELP

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

 

Data_Sample.png

Member
Posts: 69
Registered: ‎11-27-2017

Re: DAX FORMULA HELP

I hope this works

 

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

 

Good Luck!

Regular Visitor
Posts: 44
Registered: ‎06-29-2016

Re: DAX FORMULA HELP

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

 

See screenshot below. Thank you!

 

TEST.png

Community Support Team
Posts: 1,765
Registered: ‎06-24-2018

Re: DAX FORMULA HELP

Hi @alopez,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Senior Member
Posts: 389
Registered: ‎04-14-2018

Re: DAX FORMULA HELP

@alopez

 

Can you try this formula.

 

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