DAX Formula for subtracting columns?

[nielsrask]

Hi, I have created a matrix table from my data base.

Now, I would like to subtract two of the columns from each other and put the result in a new column.

Can I do it directly in the visual or is it possible for me to convert my Matrix Table visual to a query?

Thanks 

[Interkoubess]

Hi @nielsrask,

If you can five us a sample it will be great.

If I get what you are talking about, why not using a simple sum but the blank.

I am looking forward receiving your sample data.

Thanks,

[nielsrask]

Hi @Interkoubess, thanks for your reply, much appreciated!

Here is a sample: https://ascendaps-my.sharepoint.com/personal/nra_ascend_xyz/_layouts/15/guestaccess.aspx?docid=11e43...

As you can see, I have created the Matrix table on page 2 and would like to subtract the 'blank column' from the 'total' column and display the resut in a new column in the matrix table.

I would be happy, if I could just add the matrix table to my queries:-) 

[v-yuezhe-msft · Accepted solution]

@nielsrask,

Create the following measures in your table and drag the result measure in your visual.

totalforspecies = CALCULATE(SUM('EKRN-a482911f-cdbf-4b5f-9e2d-8cde02e7f164-31_05_2017_clean july 2017'[species-count]))

totalforblankaction = CALCULATE([totalforspecies],'EKRN-a482911f-cdbf-4b5f-9e2d-8cde02e7f164-31_05_2017_clean july 2017'[action-taken]="")

result = [totalforspecies]-[totalforblankaction]

For more details, please review the attached PBIX file.

Regards,
Lydia