Difference between Column Values in the Matrix Visual

Hi mohammedkhan ,

If you drag-and-dropped those columns onto your table, then Power BI automatically creates an implicit measures in the background that likely looks like SUM(Table[2015]) and SUM(Table[2016]). To calculate the difference, create a measure to subtract the second from the first:

Difference1 = SUM('Table'[2015]) - SUM('Table'[2016])

If you need to determine the size of the data corresponding to the year, the larger data is subtracted from the smaller：

Difference1 =

var test1= SUM('Table'[2015])

var test2= SUM('Table'[2016])

var test3=IF(test1>test2,test1-test2,test2-test1)

return test3

Wish it is helpful for you!

Best Regards

Lucien