Forum Discussion
Relationships
Try playing around a bit with the Cross Filter Direction on each relationship, setting them to Single, as opposed to Both, in this situation might work. That might allow you to define the relationships without making any of them inactive. Of course once you get them defined be sure to check the interactivity on the visuals you have to ensure they are reacting as necessary for your usage scenario.
Jeroenvb1I frequently work with only inactive relationships. Especially when I have a table that has multiple date columns (think Created On, Modified On, etc). I create a whole bunch of inactive relationships with my date table, then every measure has a USERELATIONSHIP argument to specify how it should behave. That way I can create as many relationships as I want and they never conflict; I just turn them on when I need them and they are ignored every other time. And since it's always stated explicitly there's never any ambiguity if I have to make changes later. I can just look at the measure instead of checking a measure and a relationship to see what it's really calculating.
@KHorseman, I'm still confused as to why the relationships Jeroenvb1 is talknig about works in PowerPivot but not Power BI. Furthermore, Power BI swapped my FROM-TO relationships when I wanted the relationships the other way. I have three tables. Let's say sales measures in one by product which is linked to a master product file that details more info on the products. Then I have a location table by state that also points to the measures table that has those same states. Why can't I show total sales of one product in a specific state? This works perfectly in PowerPivot. I must be missing something.