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.
I have a star schema w/ a Customer table, a Product table, and a Transactions table. I have a Total Sales measure
Total Sales = Calculate(SUM('Transaction'[Amount])).
On my Power BI design surface, I have two tables... One shows detail as "Customer --> Product --> Amount", and the other shows "Product --> Customer --> Amount".
When I click on a product in the top table, it filters the bottom table to that specific customer/product combination (as expected). My desired behavior is to click on a product in the top table, and have it filter to that product in the bottom table, but show ALL customers in the bottom table.
How could I accomplish this? Any help would be MUCH appreciated!
Solved! Go to Solution.
Hi @smearp ,
You can create relationships between these table as you said above, and change the Cross filter direction from Single to Both, which will take them treated as a single table.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @smearp ,
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.
Best regards
Amy Cai
Hi @smearp ,
You can create relationships between these table as you said above, and change the Cross filter direction from Single to Both, which will take them treated as a single table.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you want to show customers related to the products you filtered on, you need to enable bi-directional cross-filtering in the relationship view between products and sales, and customers and sales. Otherwise the product filter will filter sales, but will not carry through to filter customers.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |