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,
I need to calculate how many costumers bought more than one product sliced by company hierachy. I mean, a costumer may bought one product to a salesman in an office and another product to a different salesman in the same office. In that case the client will be considered multiclient for the office and the company but not for any salesman.
My input table (simplified) is something like this:.
And the result I expected would be this:I tried with count, groupby, and other but he result is always the number of products that the client bought to each hiearchy level
Thanks in advance for your suggestions!
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
27 | |
3 | |
2 | |
2 | |
2 |