Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
Solved! Go to 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.
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.
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.
@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?
@Oomsen , One of the ways is split by delimiter into rows or columns
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
56 | |
56 | |
38 | |
29 |
User | Count |
---|---|
75 | |
62 | |
45 | |
40 | |
39 |