Forum Discussion

dtartaglia's avatar
dtartaglia
Icon for Resolver I rankResolver I
10 years ago
Solved

Count number of string values in multi value columns?

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 fr...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    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

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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's avatar
    dtartaglia
    Icon for Resolver I rankResolver I
    10 years ago

    Hi Herbert,

     

    Thanks!

    Dan