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.

IDAttribute 1Attribute 2Attribute 3Attribute 4
10201
21100
32010
41021
50200
6220

0

 

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

AttributesSummary
Attribute 12
Attribute 23
Attribute 31
Attribute 40

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!
Need Help

1 Reply

  • 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: