Need Help with Relationships

[Anonymous]

Hey guys,

Thanks for taking the time to look into this message.

I have two tables: (please reference tables below)

• ID Table
• Gear Table

I have built a one to many relationship between the ID Table and Gear Table so that I can track the gear I have for each Sport. I am now trying to put together a visual that will show me the count of sports per each brand. The idea would be to have a bar graph in which the axis would be the brand and the values would be the sports. In this particular case we have three different brands (Nike, DeMarini & Under Armour) and across those brands we have two sports (baseball, football). What type of relationship am I missing here so that I can put together this visual?

ID Table

ID	Sport Name
1	Baseball
2	Softball
3	Football
4	Basketball
5	Hockey

Gear Table

ID	Sport Name	Gear	Brand
1	Baseball	Bat	DeMarini
1	Baseball	Glove	Nike
1	Baseball	Hat	Nike
2	Football	Helmet	Nike
2	Football	Uniform	Under Armour

[v-gizhi-msft · Accepted solution]

Hi,

Please try this measure:

Measure = DISTINCTCOUNT(Gear[Sport Name])

Choose Clustered Bar Chart, it shows the distinct count of sports for each brand:

Hope this helps.

Best Regards,

Giotto Zhi

[vivran22]

Hello @Anonymous,

What is value you are looking in terms of count? Can you share the expected result as per the sample table shared?

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn