Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to Solution.
@hrlope
I am not sure how your datamodel is setup but please try the following measure:
VAR _TimeOff =
CALCULATE (
SUM ( Append1[Time Off(Hours)]),
FILTER ( Append1, MONTH ( Append1[Reported Date] ) = 10 )
)
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 + _TimeOff, _TicketCount, 0 )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@hrlope
I am not sure how your datamodel is setup but please try the following measure:
VAR _TimeOff =
CALCULATE (
SUM ( Append1[Time Off(Hours)]),
FILTER ( Append1, MONTH ( Append1[Reported Date] ) = 10 )
)
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 + _TimeOff, _TicketCount, 0 )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Fowmy, This worked wonderfully. Thank you ever so much...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
35 | |
32 | |
18 | |
18 |