Forum Discussion

Oomsen's avatar
Oomsen
Helper III
4 years ago
Solved

How to use multiselected values

I got lead data from Salesforce. A lead can be active in multiple industries. In Salesforce a multiselect field can be used to select all the common industies.  I would like to show the quantity or p...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Oomsen ;

    Please try it:

    1. split column by dalimiter (";")

    2.Select all separated columns then unpivot it.

    3.create a measure to calculcate percentage.

    Measure = DIVIDE(COUNT([IndustryMuti_]),CALCULATE(COUNT([IndustryMuti_]),ALL('Table')))

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.