Tricky Sum Measure

[Anonymous]

Hi Experts

I Want to sum two columns in a table, with an expection for 3 companies in the FACT_Table. Where the company name are 

1. ABC

2. DDS

3. KKS 

we need to add an addtional value to the sum which need to be manually added to the measure they are not in the fact table

1. 900

2. 600

3. 450

All other companies are col 1 + Col 2 for total Sales.

Campnay Name	Col 1	Col 2	Result
ABC	1	2	3
DDS	1	2	3
DDS	1	2	3
KKS	1	2	3
KKS	1	2	3
KKS	1	2	3

[amitchandak · Accepted solution]

@Anonymous , expected output is not clear

a measure like

calculate(sum(Table[Col1])+sum([Col2]), Filter(Table, not Table[Company] in {"ABC", "DDS", "KKS"} ))