Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to 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"} ))
@Anonymous , expected output is not clear
a measure like
calculate(sum(Table[Col1])+sum([Col2]), Filter(Table, not Table[Company] in {"ABC", "DDS", "KKS"} ))
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |