Summary Table for Columns in different Rows

[Steels]

Cheers,

I currently have some problems visualising my data. I have multiple IDs with a full row with different attributes.

ID	Attribute 1	Attribute 2	Attribute 3	Attribute 4
1	0	2	0	1
2	1	1	0	0
3	2	0	1	0
4	1	0	2	1
5	0	2	0	0
6	2	2	0	0

I want to create a new table where the amount of a specific number (example: 2) of every attribute is summarised.

Attributes	Summary
Attribute 1	2
Attribute 2	3
Attribute 3	1
Attribute 4	0

I tried to solve the problem with this measure, but i did not find a proper way to display the data in a diagramm:

Attribute 1 =

CALCULATE(

    SUM('Table'[Attribute 1 raw]);

    'Table'[Attribute 1 raw] IN { 2 }

)

I have to use DirectQuery.
Thank you in advance!

[az38]

Hello, Steels

You can try this 

Attr1_count = calculate(COUNTROWS(FILTER(ALL('Table');Table[Attribute 1]=VALUES(Table[Attribute 1]))))
Attr2_count = calculate(COUNTROWS(FILTER(ALL('Table');Table[Attribute 2]=VALUES(Table[Attribute 2]))))
Attr3_count = calculate(COUNTROWS(FILTER(ALL('Table');Table[Attribute 3]=VALUES(Table[Attribute 3]))))
Attr4_count = calculate(COUNTROWS(FILTER(ALL('Table');Table[Attribute 4]=VALUES(Table[Attribute 4]))))

So, finaly in columns "Attr1_count" you will see count of each particular value of Attribute1 in the table, for Attribute 2 - the same: