Forum Discussion
Need Help with Relationships
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 |
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
2 Replies
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 LinkedInHi,
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
