Forum Discussion
Tricky Sum Measure
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 |
Anonymous , expected output is not clear
a measure like
calculate(sum(Table[Col1])+sum([Col2]), Filter(Table, not Table[Company] in {"ABC", "DDS", "KKS"} ))
1 Reply
Anonymous , expected output is not clear
a measure like
calculate(sum(Table[Col1])+sum([Col2]), Filter(Table, not Table[Company] in {"ABC", "DDS", "KKS"} ))