Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |