Hello! im kind of newbie in power bi, so question might be lil obvious.
I have two fact tables: Internet and Reseller. Both have almost same dimensions (geography, product) and sales, profit, cost etc columns.The only difference is that in internet sales made by customer with related dimcustomer table and reseller is same but with dimreseller.
To handle them i created bridge table, with column channel has two rows: internet and reseller. Plus added Channel column in fact tables with respective channel. And related them.
The sales measure is dax
Sum(FactInternet[Sales])+Sum(FactReseller[Sales]). It works when i change filtering in slicer between internet and reseller, but if choose customer from another visual, it shows sum of that customer sales+sum of from reseller. What is better solution for handling this kind of multiple tables and how to write measures in this cases?
thanks in advance
