Forum Discussion

AlB's avatar
AlB
Community Champion
7 years ago
Solved

DAX: doubt with expanded tables

Hi there, We have an Answers table and a Customers table related through the CustomerKey column. Customers is on the one-side of the relationship and Answers on the many-side. We have the followin...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    AlB

     

    The filter you're placing on Answer[Key] = 6 does not propagate to the Customers table. Therefore the only filter  propagating to the customer table is the answer table as it is (without Key = 6 ). 

    CALCULATETABLE will create a table filtered by Key = 6 which is then passed to CALCULATE as a filtered argument

     

    The expanded version of Customers does not contain coulmns from the Answer table, unless bi-directional filter is activated, which i dont recommend

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

Hi AlB

 

The right measure in your case should be:

 

CALCULATE (
      DISTINCTCOUNT ( Customers[CustomerKey] ),
      CALCULATETABLE( Answers, Answers[AnswerKey] = 6 )
)

 

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Thanks LivioLanzo

    Why does the first example not produce the same results as yours?

     

    Thanks

    • LivioLanzo's avatar
      LivioLanzo
      Solution Sage
      7 years ago

      AlB

       

      The filter you're placing on Answer[Key] = 6 does not propagate to the Customers table. Therefore the only filter  propagating to the customer table is the answer table as it is (without Key = 6 ). 

      CALCULATETABLE will create a table filtered by Key = 6 which is then passed to CALCULATE as a filtered argument

       

      The expanded version of Customers does not contain coulmns from the Answer table, unless bi-directional filter is activated, which i dont recommend