Forum Discussion
Calculate over Total Column
Hello Guys, Actually I'm working on a Matrix do compare the performance between my sales teams. In the actual scenario one client can be called by more than one team and today I have the followin...
" I need to achieve it with only 1 matrix"
It is possible but it comes with a lot of work attached. You may want to reconsider that requirement.
lbendlin
Super User
Super UserLet's clean up the source data first
unpivot
cleanup
Once you have your data in good shape the rest is easy.
see attached pbix