Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 following:
CALCULATE ( DISTINCTCOUNT ( Customers[CustomerKey] ), Answers, Answers[AnswerKey] = 6 )
I was expecting the filtering on Answers[AnswerKey] would be visible in Customers, filtering the customers that appear in Answers with Answers[AnswerKey]=6. My reasoning is: we have Answers as expanded table in the filter arguments and further the filter on Answers[AnswerKey]. Answers gets filtered by Answers[AnswerKey] and then, as "filtered expanded table", has an effect on Customers. It does not have any effect from what I see in the results. Would you care to explain why this is so?
Many thanks
Solved! Go to Solution.
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
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hi @AlB
The right measure in your case should be:
CALCULATE ( DISTINCTCOUNT ( Customers[CustomerKey] ), CALCULATETABLE( Answers, Answers[AnswerKey] = 6 ) )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
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
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hi @AlB
Sharing a sample of your base tables and expected result helps the community to answer. If possible please do share.
Regards,
Affan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |