Count unique rows in related table including zero

[PowerBeeEye]

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!

[Icey · Accepted solution]

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])+0

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Nathaniel_C]

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.
Nathaniel

[PowerBeeEye]

The expected results table only shows data from CompanyA, but otherwise, I believe it looks good