Create new tale count of True/False/null in for each column in dynamic report

[zy1919]

Hi,

I am quite new to PowerBI. I have a table with ID, ColA to D. How can I show a count of True/False/null in for each column as part of my Report?

Given:

ID	Col A	Col B	Col C	Col D
id1	True	True	False
id2	False	True
id3	False

Result: 

	Count True	Count False	Count Null
Col A	1	2	0
Col B	2	0	0
Col C	0	1	2
Col D	0	0	3

The table need to dynamically change with rest of the tables/charts in PowerBI report. For example, when only id1& id2 are selected, then the count in the table can adjust accordingly. 

	Count True	Count False	Count Null
Col A	1	1	0
Col B	2	0	1
Col C	0	1	1
Col D	0	0	2

[zy1919]

Hi, 

Thank you, I was able to create the Attribute table. When I try to select a certain attribute, it does not dynamically update other measure/tables in my report. I checked the Models and they are linked by Id both ways. I just want to be able to select an attribute and see what it looks like in the original table. 

For example, in my reports I have the original table and the table created from unpivoted columns. When I selected Count of True for Col A, the original table does not show the only colum with this attribute. 

[Anonymous]

Hi  @zy1919 ,

Have you solved your problem? If it's solved, you can mark the correct answer, if not, provide more detailed information and we can help you better.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

Hi @zy1919 ,

First, you need to unpivot your Col Columns.  Please see attached sample pbix for reference.