Forum Discussion
Excel 2013 PowerPivot DAX - Getting the correct value with criterias on different tables
Hello, I have the following tables. I like to accomplish similar to this post (Sum of values based on distinct values in other column), where given the slicerTable[Province], or slic...
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?