cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## 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 percentage of leads per industry. PBI is currently creating a unique value for every industry combination. Below a attached a printscreen of the data.

1 ACCEPTED SOLUTION
Community Support

Hi, @Oomsen ;

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.

5 REPLIES 5
Community Support

Hi, @Oomsen ;

According to your description, you could add index column and ,then modify the measure:

2.modify the measure.

Measure = DIVIDE(COUNT([IndustryMuti_]), CALCULATE(MAX([Index]),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.

Community Support

Hi, @Oomsen ;

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.

Helper III

@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.

Helper III

@amitchandak thanks for the respond. I splitted the column.
The question now is how can i use the seperate columns to identify my leads by industry?

Super User

@Oomsen , One of the ways is split by delimiter into rows or columns

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/