Forum Discussion
Count unique rows in related table including zero
Hello,
I have two tables that look like this:
| GroupNames |
| Group A |
| Group B |
| Group C |
| CompanyName | GroupName | MemberName |
| CompanyA | GroupA | MemberA |
| CompanyA | GroupA | MemberA |
| CompanyA | GroupA | MemberB |
| CompanyA | GroupB | MemberC |
| CompanyB | GroupA | MemberD |
I would like to create a visualizer with a table that looks like this:
| GroupName | MemberCount |
| GroupA | 2 |
| GroupB | 1 |
| GroupC | 0 |
Note that MemberCount counts only unique MemberName instances for each GroupName.
There would be a slicer for CompanyName.
Thanks in advance!
Hi PowerBeeEye ,
Try this:
1. Be careful of unnecessary spaces. Remove the sapces in the table below.
GroupNames Group A Group B Group C 2. Create relationships.
3. Create a measure.
Count = DISTINCTCOUNT(Company[MemberName])+0Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
3 Replies
Hi PowerBeeEye ,
Try this:
1. Be careful of unnecessary spaces. Remove the sapces in the table below.
GroupNames Group A Group B Group C 2. Create relationships.
3. Create a measure.
Count = DISTINCTCOUNT(Company[MemberName])+0Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi PowerBeeEye ,
Please check your expected results, you have four unique choices, and only 3 count.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
NathanielThe expected results table only shows data from CompanyA, but otherwise, I believe it looks good
