Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Oomsen
Helper III
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. 

SF industry.PNG

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @Oomsen ;

Please try it:

1. split column by dalimiter (";")

vyalanwumsft_0-1630897536310.png

2.Select all separated columns then unpivot it.

vyalanwumsft_2-1630897651678.png

3.create a measure to calculcate percentage.

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

The final output is shown below:

vyalanwumsft_3-1630897886873.png

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.

View solution in original post

5 REPLIES 5
v-yalanwu-msft
Community Support
Community Support

Hi, @Oomsen ;

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

1.add index column.

vyalanwumsft_0-1630977499482.png

2.modify the measure.

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

The final output is shown below:

vyalanwumsft_1-1630977619551.png

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
Community Support
Community Support

Hi, @Oomsen ;

Please try it:

1. split column by dalimiter (";")

vyalanwumsft_0-1630897536310.png

2.Select all separated columns then unpivot it.

vyalanwumsft_2-1630897651678.png

3.create a measure to calculcate percentage.

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

The final output is shown below:

vyalanwumsft_3-1630897886873.png

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 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
Helper III
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?

amitchandak
Super User
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/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors