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 from the selected red part of the column.

 

Thanks,

Dan

 

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

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

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

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        10 years ago

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

  • 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