Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Solved! Go to 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.
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.
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
Proud to be a Super User!
The expected results table only shows data from CompanyA, but otherwise, I believe it looks good
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |