cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alopez Regular Visitor
Regular Visitor

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

4 REPLIES 4
Highlighted
HarrisonCbe Member
Member

Re: DAX FORMULA HELP

I hope this works

 

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

 

Good Luck!

alopez Regular Visitor
Regular Visitor

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
Community Support Team

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.
themistoklis New Contributor
New Contributor

Re: DAX FORMULA HELP

@alopez

 

Can you try this formula.

 

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