Forum Discussion
Helper IVCalculate difference between columns in the matrix
Found a solution.
In case anyone stucked here is a good starting point: Solved: Difference instead of Total in PowerBI Matrix - Microsoft Fabric Community
Helper IVHi lbendlin - that's actually a fair point...
So let's say we will limit selection to 2 categories only, but how to make it dynamic, as the configuration might be different, one may select Category 1 and 2, other one Category 1 &3 and other one 4&2 and so on... and we want to compute the difference and diff % between selected categories.. hope it makes sense.
- lbendlin
Super User
I would go with Visual Calculations - they have a concept of PREVIOUS where you can look sideways in a visual and compare to the neighboring values.
- Kopek
not sure it will work either as we want to have one column for difference and one for diff%, not category columns split by new columns,..
- lbendlin
Correct, you can only abuse the Column Totals once.
You would be looking into creating a custom matrix with a reference table for the desired column names and a measure to do the switching. This becomes very ugly very quickly and is frankly not worth the effort.
