Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"} ))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |