Forum Discussion

alderete-tomas's avatar
alderete-tomas
Frequent Visitor
3 years ago
Solved

Join paths are expected to form a tree

I have 5 tables: Calendar (C), Sales (S), Profit Center Attributes (PC), Employees (E), Attendance (A). I have them joined as follows:  1. C[Date] (1:m) E[First Day of Month] 2. C[Date] (1:m) A[Da...
Need Help
  • alderete-tomas's avatar
    alderete-tomas
    3 years ago

    It's been solved by keeping the relationship bewteen E and A inactive (but existing), then applied in the measure I needed "CROSSFILTER(PC[Center], Employees[Center], OneWay_LeftFiltersRight))".

     
    Thanks for your time, indeed.
alderete-tomas's avatar
alderete-tomas
Frequent Visitor
3 years ago

It's been solved by keeping the relationship bewteen E and A inactive (but existing), then applied in the measure I needed "CROSSFILTER(PC[Center], Employees[Center], OneWay_LeftFiltersRight))".

 
Thanks for your time, indeed.