Forum Discussion
Calculate the difference between two columns in a matrix when each row is a measure.
Hello, I'm working on a matrix in Power BI that compares transaction types ACTUAL vs FORECAST. Each row is it's own calculated measure. Is there any possible way to create a difference column? ...
Due to the fact that the measures used different figures in their calculations (volumes, revenue, etc.), I determined that it was not possible to achieve what I needed to via a matrix. I had to resort using cards with visual level filters for each field. It worked, but it took a long time to construct.