Forum Discussion
saud968
Memorable Member
Memorable MemberSlicer affecting the dax
I have the below 2 measures, further i have a calculated column - P1 Hour = IF(support__cw_ops_manage_case_merge[Priority] = "P1 - Critical" && support__cw_ops_manage_case_merge[Response Hour]>0 &...
This was resolved
Response Case Volume =CALCULATE([Case Volume],FILTER(support__cw_ops_manage_case_merge,support__cw_ops_manage_case_merge[RESPONSE_SLA_MINUTES] <> BLANK()&& (support__cw_ops_manage_case_merge[Priority] = "P1 - Critical"|| support__cw_ops_manage_case_merge[Priority] = "P2 - High"|| support__cw_ops_manage_case_merge[Priority] = "P3 - Medium"|| support__cw_ops_manage_case_merge[Priority] = "P4 - Low"|| support__cw_ops_manage_case_merge[Priority] = "Non-Priority")))
saud968Memorable Member
Memorable MemberThis was resolved
Response Case Volume =
CALCULATE(
[Case Volume],
FILTER(
support__cw_ops_manage_case_merge,
support__cw_ops_manage_case_merge[RESPONSE_SLA_MINUTES] <> BLANK()
&& (
support__cw_ops_manage_case_merge[Priority] = "P1 - Critical"
|| support__cw_ops_manage_case_merge[Priority] = "P2 - High"
|| support__cw_ops_manage_case_merge[Priority] = "P3 - Medium"
|| support__cw_ops_manage_case_merge[Priority] = "P4 - Low"
|| support__cw_ops_manage_case_merge[Priority] = "Non-Priority"
)
)
)
