How to use multiselected values

[Oomsen]

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. 

[v-yalanwu-msft]

Hi, @Oomsen ;

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

1.add index column.

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.

[v-yalanwu-msft · Accepted solution]

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]

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

[Oomsen]

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

[amitchandak]

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

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