How to create a table with calculations

Question

Hello,&nbsp;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:&nbsp;Id&nbsp;Error1&nbsp;Error2&nbsp;Error3&nbsp;a&nbsp;0&nbsp;0&nbsp;1&nbsp;b&nbsp;0&nbsp;1&nbsp;0&nbsp;c&nbsp;1&nbsp;0&nbsp;1&nbsp;&nbsp;The result column should be:&nbsp;Error&nbsp;Count&nbsp;Error1&nbsp;1&nbsp;Error2&nbsp;1&nbsp;Error3&nbsp;2&nbsp;&nbsp;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.&nbsp;Is it possible to do something like this in Power BI?Thank you in advance.

amitchandak · Accepted Answer

T_von_Axt , Unpivot the error columns in power query then you can do a simple sum 
&nbsp;
Or
&nbsp;
in matrix visual put them in values, and enable show on row

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

Forum Discussion

How to create a table with calculations

2 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Create calculated table from two tables

Direct Lake Model - Calculated Column/Tables

Error	Count
Error1	1
Error2	1
Error3	2