Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 -