Forum Discussion
Need help in getting the difference
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 section2018=CALCULATE ( Expression, Table1[Year] = 2018 ) 2017=CALCULATE ( Expression, Table1[Year] = 2017) Difference = [2018] - [2017]
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]
