Forum Discussion
Solved
Distinct Count if item Is This
I have a data set with Owner, Collaborator Type, and Folder. Owners can own multiple folders and each folder has a Collaborator Type of external or managed. I'd like to be able to get a distinct c...
It looks like you've added a calculated column with that code.
The code is actually a measure definition, and won't make sense in a calculated column.
Here's a sample pbix file using your sample table
It looks like you've added a calculated column with that code.
The code is actually a measure definition, and won't make sense in a calculated column.
Here's a sample pbix file using your sample table
This is really helpful. Can you/anybody please help me with a similar but slightly different scenario where I want to identify (for simplicity's sake I will use the same example) the number of unique Owner's who have both a "Managed" AND "External" Collaborator Type? Thanks in advance - I'm very new to PowerBI! Cheers.