Forum Discussion
Microsoft EmployeeHow to right outer join instead of crossfilter visualizations?
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!
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.
3 Replies
- edhans
Community Champion
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.
v-xicaiCommunity Support
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.
