Related table

[Anonymous]

Hi 

I am New to PowerBI

I have two tables

Table 1

Category

Mech

Teck

Eng

Table 2 

Category   ID

Mech        123

Teck          124 

Eng            125

Mech         126

Eng             127

How do I count no of people in table 2 based on ID and list against category in Table 1.

[Angith_Nair]

Hi @Anonymous ,

First of all, make a relationship between Table 1 & Table 2 on Category column. It will be one to many relationship. Then plot a table in which add Category column from Table 1 and then add ID column from Table2. This will give the count of no of ID's against category. I'm adding the pbix file for your reference. 

Click Here. 

If this works, kindly mark it as a solution. Appreciate with kuddos.