Forum Discussion

Steels's avatar
Steels
New Member
7 years ago

Summary Table for Columns in different Rows

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...
Need Help
az38's avatar
az38
Community Champion
7 years ago

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: