Forum Discussion

saud968's avatar
saud968
Icon for Memorable Member rankMemorable Member
2 years ago
Solved

Slicer 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 &...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • saud968's avatar
    saud968
    2 years ago

    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"
           
            )
        )
    )
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Slicers and other filters cannot affect calculated columns.  Calculated columns are called calculated columns because they are calculated once, during semantic model refresh, and then never again.