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.
I have a set of users with a product installed, some have Pro and some have Standard and some have both. I want to count the ones who only have Pro, the ones who only have Standard and the ones who have both. Sameple dataset below
Chad has both installs, while Sarah and Jeff only have one install..
I had tried a calcualate(user), (version = "pro") && (verison ="stnadard")... excuse the syntext.. new to it... but this didn't work?
Product | Version | User |
Adobe | Pro | Chad |
Adobe | Standard | Sarah |
Adobe | Standard | Chad |
Adobe | Pro | Jeff |
Solved! Go to Solution.
I agree with @JustJan . Matrix is all thats needed really.
You can even go about it slightly differently. If you would rather view by Employee , and their number of subscriptions -
I agree with @JustJan . Matrix is all thats needed really.
You can even go about it slightly differently. If you would rather view by Employee , and their number of subscriptions -
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |