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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
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.

Oomsen's avatar
Oomsen
Helper III
4 years ago

v-yalanwu-msft this works well. But the % is now calculated based on the total of options. For example tank storage is 5 out of 15. But in my example there where only 12 lines, meaning only 12 leads. Some without a industry and some with multiple. When a lead have multiple industries it should be counted in all the options.