Forum Discussion
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.
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.
5 Replies
Oomsen , One of the ways is split by delimiter into rows or columns
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
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?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 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.
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.
