Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Related table

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.

1 Reply

  • Angith_Nair's avatar
    Angith_Nair
    Icon for Continued Contributor rankContinued Contributor
    5 years ago

    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.