How to create a table with calculations

[T_von_Axt]

Hello,

I am currently having trouble with implementing a solution that checks if certain columns are either 0 or 1 and create a table where rows are the sum of the number of lines with 1 for each column. Something like this:

Id	Error1	Error2	Error3
a	0	0	1
b	0	1	0
c	1	0	1

The result column should be:

Error	Count
Error1	1
Error2	1
Error3	2

I also need it to be possible, that if I click a row in the second table, it will filter the other tables to show only entries with the Ids that contain that error.

Is it possible to do something like this in Power BI?

Thank you in advance.

[T_von_Axt]

Thank you. It worked perfectly 🙂

[amitchandak · Accepted solution]

@T_von_Axt , Unpivot the error columns in power query then you can do a simple sum

Or

in matrix visual put them in values, and enable show on row