Question

Expression refers to multiple columns. Multiple columns cannot be converted to a scalar value

Answer 1

Answer:It is a summarizing error in microsoft  where when someone went to summarize a table in to a single expression to understand the relationship of the different columns but it gives syntax error.

Step-by-step explanation:The following steps can be followred to solve the problem :-

1. One has to drag multiple columns into a single column to display the combined data.
2. If same value is desired in multiple rows then one can use command :- calculate(SUM(ChargeActivity[column 1]), ALLEXCEPT(ChargeActivity, ChargeActivity[column 2], ChargeActivity[column 3]).
3. If result is to be obtained irrespective of  number of rows then the command used is :- SUMX(CROSSJOIN(values(column 2), values(column 3)), calculate(SUM(ChargeActivity[column 1])).