Forum Discussion

PowerBeeEye's avatar
PowerBeeEye
Icon for Microsoft Employee rankMicrosoft 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.

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
5 years ago

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's avatar
PowerBeeEye
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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