Forum Discussion
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 ...
Angith_Nair
Continued Contributor
Continued ContributorHi 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.
If this works, kindly mark it as a solution. Appreciate with kuddos.