2 DirectQuery Summed in a Calculated Column in Combined Table - Not Summarizing in Matrix correctly

[sjh5959]

Hi, I have two DirectQuerys that are combined into a Combined Table, and then a simple sum between two columns in a Calculated Column (MTMDelta + ADJUSTMENT).

Adj MTM Delta = 'Combined Table'[MTM Delta]+ 'Combined Table'[Query1.ADJUSTMENT]

The Data is correct in the Calculated Column, but then once the data is in a Matrix visual it is not summarizing correctly. The output will be like $1,000 + $0 = $12,300,000. It appears that this is because a Calculated Column cannot take a filter properly. I am using a filter of COB_DATE= [date]. I cannot simply create a Measure and skip the Calculated Column, because the underlying data is two DirectQuerys. Is there a way around this bug in the visual?

Thank you!

[V-pazhen-msft]

@sjh5959 

Can you share a short sample? There are some differences in the display of matrix and table. I am not quite sure about how does the bug you mentioned look like in a matrix. Or you may just use the Table visual instead.

Paul Zheng _ Community Support Team

[amitchandak]

@sjh5959 , that seems strange. First of check data type of both the base column and the new column. They should be decimal or whole number .

If need a create a measure and try

measure = sum(Table[Adj MTM Delta])