Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'm trying to get to the total number of distinct advisers in a team when looking, when an indiviudal is selected.
This is what I have tried:
In the TeamMember Count field, I'm expecting it to display 9 as there are only 9 members in the Life team that have a Total > 0
Thanks
Rob.
Solved! Go to Solution.
I've manged to figure it out, by getting it to calculate the first part then, Calculate the All and AllExcept, Calculation below:
@amitchandak Thank you for your response.
I have attached sample pbix file, with very basic made up data, but the same style of how the my acutal tables are linked.
In the example file attached, I would expect the TotalAdviser Count to equal 4 as only 4 out of the 10 advisers have quoted in that Team.
pbix file uploaded to file.io
Thanks
@TonicQuake ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I've manged to figure it out, by getting it to calculate the first part then, Calculate the All and AllExcept, Calculation below:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
78 | |
69 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |