Forum Discussion
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...
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
