Forum Discussion
Excel 2013 PowerPivot DAX - Getting the correct value with criterias on different tables
I don't know for sure that relating your lookup table and slicer table is the "best" way to go -- but it should certainly be *a* possible solution. Easiest is probably just to include Profit Center in your slicer table and relate via that column... making real sure the relationship is flowing the current direction (slicer table is the 1 side, lookup table is the many side... though, maybe just use 1:1).
It is also possible to do without the relationship, but we will need to adjust the measures to basically create a "virtual relationship"
Tried to do what you asked, which is having the [Profit Center] at the slicerTable and then create a relationship with the lookupTable, along with the previous' post formula(s) that you've wrote and still didn't get the correct result.
Anyone has a solution for this?
Been playing around for weeks and still not solution.
Perhaps, there's no solution at all with what I'm trying to accomplish?