Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 th...
  • amitchandak's avatar
    4 years ago

    Anonymous , expected output is not clear

     

    a measure like

     

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