calculating the difference between two lines

[Anonymous]

Hello I have a concern please. I would like to have the result of this table in dax, that is to say income-expenditure knowing that I have created a group where other are the income and other are the expenses.

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Because in the measure, when I use the column, it will return to the value of the column itself to me, as follows, I made the relevant adjustments to the data and got still their difference, in addition to the field total can be adjusted to another name by itself（the max in measure not get the max value ,and it get the base value ,it equare you create a new column that is new column=value):

Best Regards

Lucien

[v-luwang-msft]

Hi  @Anonymous ,

Create measure like the below:

TEST = 
IF (
    HASONEVALUE ( 'Table'[Type1] ),
    MAX ( 'Table'[value] ),
    CALCULATE ( MAX ( 'Table'[value] ), FILTER ( 'Table', 'Table'[Type1] = "A" ) )
        - CALCULATE ( MAX ( 'Table'[value] ), FILTER ( 'Table', 'Table'[Type1] = "B" ) )
)

Best Regards

Lucien

[Anonymous]

Please what is 'table'[value]

[v-luwang-msft]

Hi @Anonymous ,

The data in the table used to become the values in the matrix you created, are as follows:

Best Regards

Lucien

[Anonymous]

And as it is several columns which are on value how to do it please? In your case it's A1 and A2 how to put them in MAX