Forum Discussion
Solved
Multiple tier rollup
In the example below, I have created a calculated column "Profit Per Unit" using the following expression: Profit Per Unit = Divide('Titan_DMS qryNVunitsandGP'[Profit],('Titan_DMS qryNVunitsandGP...
You need to add a measure instead.
Hi v-chunz
This does not work for graphs.
It works fine in the table format but when you used the new measure "Profit per unit", it adds up all the individual Profit Per Unit calculations and displays the aggregate total on the line chart which is completely wrong.
Thanks v-chunz
This now works perfectly.
I hadn't appreciated the difference between adding a measure and adding a column.
Cheers