Power BI and Azure Data Platform

Survey DAX pattern

Survey explained on DAX patterns site

• Basic pattern example

• Complete pattern example

  This DAX version includes checks to handle special conditions.

  CustomersQ1andQ2 = SWITCH (
    TRUE,
    NOT ( ISCROSSFILTERED ( Filter2[AnswerKey] ) ), [CustomersQ1],
    NOT ( ISCROSSFILTERED ( Filter1[AnswerKey] ) ), [CustomersQ2],
    IF (
        HASONEVALUE ( Filter1[Question 1] )
            && HASONEVALUE ( Filter2[Question 2] ),
        IF (
            VALUES ( Filter2[Question 2] )
                <> VALUES ( Filter1[Question 1] ),
            CALCULATE (
                COUNTROWS ( Customers ),
                CALCULATETABLE (
                    Answers,
                    USERELATIONSHIP ( Answers[AnswerKey], Filter2[AnswerKey] )
                ),
                CALCULATETABLE (
                    Answers,
                    USERELATIONSHIP ( Answers[AnswerKey], Filter1[AnswerKey] )
                )
            )
        )
    )
  )
  

  This sample has separate pages with a single slicer and two slicers.

Return to:

Top

Basket Analysis DAX pattern

Back to overview of DAX patterns

Home