Calculated table values are different with report table

[Anonymous]

Hi - I'm trying to count the negative values under [MSU Per Week Gap vs Target], but I'm unable to due to some conditions that I have no clue about.

I've done some troubleshooting and stumbled upon this - different results of [MSU Per Week Gap vs Target]

Report table:

Calculated table:

The other columns is the reference surrounding [MSU Per Week Gap vs Target]

The syntax for [MSU Per Week Gap vs Target] = 

[MSU Per Week Gap vs Target] = SWITCH(
                TRUE(),
                [Forecast (MSU)]<= 0,0,[Inventory (MSU)] - [BU Target Inventory (MSU)])

Hoping an expert could reach me via MS Teams or anything so I could discuss in detail

[wdx223_Daniel]

try to remove all the added columns in the SUMMARIZE, and add them by ADDCOLUMNS

calcultetable(addcolumns(summarize(),"x",...,"y",....),....)