cancel
Showing results for 
Search instead for 
Did you mean: 
0

DAX Multiple calculations

I want to ADD Append1,[Time Off(Hours)] to Append1[Hours Reported] prior to the division. Any suggestions?

 

VAR _HoursReported = Calculate(SUM(Append1[Hours Reported]),FILTER(Append1, Month(Append1[Reported Date]) = 10))
Var _TicketCount = Calculate(DISTINCTCOUNT(Append1[Number]),FILTER(Append1,Append1[Assignment group] IN {"DC - US - DDC - Hardware","DC - US - EDC - Hardware","DC - US - Impl and Maint DNG/EGV","DC - US - Planners" } && Month(Append1[Created] ) = 10 ))
RETURN
DIVIDE(_HoursReported,_TicketCount,0)

Status: Delivered

Hi, 

If you want to get a solution for this kind of DAX problem as soon as possible, I suggest you to open a case in the DAX community so that experts in DAX can help you in advance.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Comments
v-robertq-msft
Community Support
Status changed to: Delivered

Hi, 

If you want to get a solution for this kind of DAX problem as soon as possible, I suggest you to open a case in the DAX community so that experts in DAX can help you in advance.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

hrlope
New Member

Thank you for this guidance