Forum Discussion

PowerBeeEye's avatar
PowerBeeEye
Microsoft Employee
5 years ago
Solved

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 Mem...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    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.

Icey's avatar
Icey
Community Support
5 years ago

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.