how to summarize data, count category variable

fiorela solution attached, look at table(2), lot of heavy lifting is done in power query

- added index column

- unpivoted the table

and then everything was very easy

Hi,

In the Query Editor, add an Index column.  Click on the Index heading and select "Unpivot Other olumns".  Build a matrix visual and drag Attribute to the row labels.  Drag the 3rd column to the column labels.  Write this measure

=COUNTROWS(Data)

Hope this helps.