NaN error

Hey Anonymous ,

what exactly do you want to do?

For me it looks like these are all calculated columns. Calculated column are statis, that means they are created when the file is loaded and won't change anymore afterwards. For example when you use a slicer, it won't change the content of the column.

In your case the new calculated column [Vol Growth '19-'20] will perform the operation line by line once the file is loaded. I'm not really sure if you want that.

Usually you want the whole thing to be interactive. For that you would use a measure. If you create a measure the columns need aggregation. So as a measure you would write:

Vol Growth '19-'20 = ( SUM( 'Img Div_Img'[2020 Vol]) - SUM( 'Img Div_Img'[2019 Vol]) ) / SUM( 'Img Div_Img'[2019 Vol])