Count number of string values in multi value columns?

[dtartaglia]

Hi,

I'm sure this is an easy one but can't seem to figure it out. All I want to do is display a tooltip for the total number of users in a selected column. The below image shows the user count from the selected red part of the column.

Thanks,

Dan

[v-haibl-msft · Accepted solution]

@dtartaglia

You can use following measure to display the total number of users in a selected column.

User Count_2 =
CALCULATE (
    DISTINCTCOUNT ( SurveyDataTransposed[Name] ),
    ALLEXCEPT ( SurveyDataTransposed, SurveyDataTransposed[Studio] )
)

Best Regards,

Herbert

[dtartaglia]

Hi Herbert,

Thanks!

Dan

[Greg_Deckler]

So you have this working or is that a mock-up of what you want? Any chance you can provide sample data?

[dtartaglia]

I do not see how to attach a pbix.

[Greg_Deckler]

Most times people put the pbix on their personnel OneDrive and share it.

[dtartaglia]

Here is the file:

https://nbbj.sharefile.com/d-sa8a30d360e4406fb