Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |