Organizing column for a table

[syasmin25]

Hello, 

I have the following table.

And, I am trying to recreate something like the image below,

I was thinking of creating conditional columns inside power bi that would seperate the groups at the image above and then do an unpivot. However, my actual dataset is pretty huge and I am trying to avoid the row counts from getting even large. I was wondering if there is any other cleaner way to do this. Please let me know. 

Thank you

[CNENFRNL]

Hi, @syasmin25 , I attached a pbix file for your reference for such a headcount senario.

[amitchandak]

@syasmin25 , Create a measure

count(Table[ID])  and put that in visual with subject