Forum Discussion
saud968
Memorable Member
Memorable MemberIncorrect average
AGE 70 27 25 9 4 4 2 9 7 2 0 3 2 0 0 13 0 3 0 6 0 1 6 4 15 4 6 13 5 3 11 3 4 2 0 0 1 2 2 1 2 5 0 1 4 5 4 4 3 3 3 4 1 2 1 2 1 7 1 0 1 8 0 5 0 7 6 4 1 3 1 In Excel the average for this is 5.04, howeve...
Thank you for reviewing it. I was able to get the correct average with the below dax
TTR2 =VAR AvgAge1 =AVERAGEX (FILTER ('support__cw_ops_manage_case_merge_temp','support__cw_ops_manage_case_merge_temp'[ClosedCaseFlag] = TRUE ()),'support__cw_ops_manage_case_merge_temp'[AGE])VAR AvgAge2 =AVERAGEX (FILTER ('SUPPORT__CW_OPS_VOLUME_FRESHDESK_FORTIFY_SPS','SUPPORT__CW_OPS_VOLUME_FRESHDESK_FORTIFY_SPS'[ClosedCaseFlag] = TRUE ()),'SUPPORT__CW_OPS_VOLUME_FRESHDESK_FORTIFY_SPS'[AGE_IN_DAY])RETURNAvgAge1 + AvgAge2
HotChilli
Community Champion
Community ChampionHow does the DAX shown relate to the data you have posted?
--
The DAX refers to 2 tables and, it looks to me, that the CALCULATE is redundant and then 2 averages are getting added together.
So, if the average of each table's value is around 5, adding them together will give 10. That may explain why you get 10 but I'm still confused about the data and the dax shown.
saud968Memorable Member
Memorable MemberThank you for reviewing it. I was able to get the correct average with the below dax
TTR2 =
VAR AvgAge1 =
AVERAGEX (
FILTER (
'support__cw_ops_manage_case_merge_temp',
'support__cw_ops_manage_case_merge_temp'[ClosedCaseFlag] = TRUE ()
),
'support__cw_ops_manage_case_merge_temp'[AGE]
)
VAR AvgAge2 =
AVERAGEX (
FILTER (
'SUPPORT__CW_OPS_VOLUME_FRESHDESK_FORTIFY_SPS',
'SUPPORT__CW_OPS_VOLUME_FRESHDESK_FORTIFY_SPS'[ClosedCaseFlag] = TRUE ()
),
'SUPPORT__CW_OPS_VOLUME_FRESHDESK_FORTIFY_SPS'[AGE_IN_DAY]
)
RETURN
AvgAge1 + AvgAge2