Forum Discussion
Incorrect Measure Total on Matrix
Hello, I have a matrix in a report that contains a number of measures, unfortunately the measure total is incorrect for each one. I have been trying to find a solution but have so far had no luck,...
All,
I have managed to resolve the issue with the total. Rather than using a simple multiplication, I created a measure for the middle subtraction and then used SUMX to multiply this value by the price and it has worked.
Cheers,
Josh