Forum Discussion

i820017's avatar
i820017
Resolver II
3 years ago
Solved

Measure with Filter Question

I have 2 measures as seen below. % Of Completion = DIVIDE(SUM('ops vw_SurveyDetails'[Survey Completion]), [Survey_Count]) % of Completion w/out = CALCULATE(DIVIDE(SUM('ops vw_SurveyDetails'[Surv...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi i820017 

    Can you offer the sample data you have descibed, based on the information you have offered, you can refer to the following example

    Type_Measure =
VAR _values1={"Survey Completed", "Survey not Completed","Survey not Offered"}
VAR _values2={"Survey Completed", "Survey not Completed"}
SWITCH (
    TRUE (),
    SELECTEDVALUE('ops vw_SurveyDetails'[MediaType] ) = "Chat", CALCULATE([% Of Completion],'ops vw_SurveyDetails'[EventStatus] IN  _values2),SELECTEDVALUE('ops vw_SurveyDetails'[MediaType] ) = "Call", CALCULATE([% Of Completion],'ops vw_SurveyDetails'[EventStatus] IN  _values1),[% Of Completion])

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi i820017 

You can refer to the following measure

Type_Measure =
SWITCH (
    TRUE (),
    OR (
        MAX ( 'ops vw_SurveyDetails'[MediaType] ) = "Call",
        AND (
            CONTAINSSTRING ( MAX ( 'ops vw_SurveyDetails'[MediaType] ), "Chat" ),
            CONTAINSSTRING ( MAX ( 'ops vw_SurveyDetails'[MediaType] ), "Call" )
        )
    ), [% Of Completion],
    MAX ( [MediaType] ) = "Chat", [% of Completion w/out]
)

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • i820017's avatar
    i820017
    Resolver II
    3 years ago

    This dax measure doesn't yield the results that I need it to yield.

     

    I apolgize for being unclear, but I want to create a measure called '%_of_Completion' = DIVIDE(SUM('ops vw_SurveyDetails'[Survey Completion]), [Survey_Count])

    Then, when I click on the 'MediaType' slicer for 'Call' then all columns under 'EventStatus' should show up (in the DAX measure). The columns under 'EventStatus' are 'Survey Completed', 'Survey not Completed', and 'Survey not Offered').

    When I click on the 'MediaType' slicer for 'Chat' then only certain columns under 'EventStatus' should show up (in the Dax measure). The columns that should show up are 'Survey Completed' and 'Survey not Completed'.

    When neither 'Call' nor 'Chat' are selected, then all columns under 'EventStatus' should show up (in the DAX measure).

     

    I am using the DAX measure to create a line graph as seen below. 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi i820017 

      Can you offer the sample data you have descibed, based on the information you have offered, you can refer to the following example

      Type_Measure =
VAR _values1={"Survey Completed", "Survey not Completed","Survey not Offered"}
VAR _values2={"Survey Completed", "Survey not Completed"}
SWITCH (
    TRUE (),
    SELECTEDVALUE('ops vw_SurveyDetails'[MediaType] ) = "Chat", CALCULATE([% Of Completion],'ops vw_SurveyDetails'[EventStatus] IN  _values2),SELECTEDVALUE('ops vw_SurveyDetails'[MediaType] ) = "Call", CALCULATE([% Of Completion],'ops vw_SurveyDetails'[EventStatus] IN  _values1),[% Of Completion])

      Best Regards!

      Yolo Zhu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      • i820017's avatar
        i820017
        Resolver II
        3 years ago

        This DAX script worked...thanks!!