Count The Number of subcategories in matrix

[Anonymous]

I want to count the number of subcategories. Data looks like below:

Rank     			Vendor Group
Elite	       		Avot
Elite	           	Ivak
Essential			Boch LTD
Essential			Futh Elec
Provisional			Active Dach
Provisional			Alloc Mac
Provisional			Alldoc
Provisional			Anpro
Provisional			Falow
Provisional			Match
Provisional			Beast Elec

The data above is a matrix. Vendor group is a column that comes from Vendor Info Table and Rank is a measure calculated based on their score calculated using another measure. I want to count how many Elites and how many Provissonals we have in different card or table. How can I do this please?

[Anonymous]

I am only getting the total number of vendor groups as shown in snippet above. 

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

First create a dim table as below:

Then create a measure as below:

Measure 2 = 
SWITCH(SELECTEDVALUE('Dim table'[Column1]),"Elite",CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Measure]="Elite")),
"Essential",CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Measure]="Essential")),
"Provisional",CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Measure]="Provisional")))

Finally you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[samdthompson]

Hello, try making this measure:

=COUNTROWS(Table)

here it is at work: