CODEWITHSUNDEEP
powerbidax
Sca
Sca

Reputation: 195

To display "total" (sum ) of each row using DAX in Power BI

I have the following format of data :

Machine Name | Error_code_a | Error_code_b | Error_code_c | Error_code_d 
MA01         |   0          |  1           |     0        | 0
MA02         |   1          |  0           |     1        | 0
MA02         |   1          |  1           |     1        | 0

Where 0 and 1 simply represents if an error code is present or absent.

I need one column where the TOTAL or SUM is displayed.

Example for MA01, the sum column should show 1 , for MA02 it should show 2 (since 1+1).

I am able to do this column wise, but need some DAX query for doing it row wise.

Upvotes: 0

Views: 577

Answers (1)

Sca
Sca

Reputation: 195

so turns out it was pretty straight forward! We need to create a new column / custom column / measure and then : MySum = [error_code_a] + [error_code_b] + [error_code_c] + so on and you will get a new column which is basically summing up each row!

Upvotes: 1

Related Questions