How to replicate a SAP BO calcuated column using DAX

Question

Hi

I am trying to create a calculated column which is originally written in SAP BO as below

=NoFilter(Sum(([Column A])) In ([Table].[Column 1] ; [Column 2]))

I tried to write the same thing using DAX like below

= Calculate(SUM(column A), ALLEXCEPT(Table, Column 1, column 2))

But it is not showing results as expected.

Please advise....

Answer 1

Could you explain SAP BO expression so we could work on the DAX?

What is the relation between [Column A] [Column 1] [Column 2] and [Table] ?

Answer 2

From what you described :

= Calculate(SUM(Table[amount]), ALLEXCEPT(Table, Table[Column 1], Table[column 2]))

Should be right.

If not, please share some example of what is expected. And have you sliced the table with column 1 and column 2 ? What is you current issue looks like ?