Need help in getting the difference

[chua129]

Hi Everyone,

I need help in getting the difference between two columns. I want to get the difference of those number in 2017 and in 2018. The 2017 and 2018 is inside the same column.

Thanks!

[Zubair_Muhammad]

@chua129

Try this pattern

Measure =
CALCULATE ( Expression, Table1[Year] = 2018 )
    - CALCULATE ( Expression, Table1[Year] = 2017 )

[chua129]

What do I put for the Expression? COUNT(...)?

[Zubair_Muhammad]

Yes

[chua129]

I have obtained the difference. However, it is showing at every part of the column as shown in the image below. Is it possible to make something like:

Year                  2017    2018 Difference

With Mobile    7            5         -2

[Zubair_Muhammad · Accepted solution]

@chua129

This is unfortunately the problem with Using Columm Field.

You will get a MEASURE for each distinct value of the Column

There are 2 ways to deal with it

1) you can hide the extra MEASURE Column...hide the totals.....But you will have to adjust the Word wrap properties

I do not recommend this.

2) Another approach is to Remove the YEAR from columns and instead use 3 MEASURES as follows.
Put these MEASURES in the VALUES section

2018=CALCULATE ( Expression, Table1[Year] = 2018 )

2017=CALCULATE ( Expression, Table1[Year] = 2017)

Difference = [2018] - [2017]

[chua129]

The second approach works like wonder!

Thanks @Zubair_Muhammad 

You saved my life! 🙂