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.
Hi,
I want to classify towns based on their volume in different segment. Following is the example dataset:
Town Name | Brand Name | Category | Segment | Volume |
Jaipur | ABC | Shampoo | Deluxe Shampoo | 100 |
Jaipur | DEF | Shampoo | Deluxe Shampoo | 50 |
Jaipur | GHI | Shampoo | Deluxe Shampoo | 40 |
Jaipur | JKL | Shampoo | Deluxe Shampoo | 120 |
Ajmer | ABC | Shampoo | Deluxe Shampoo | 90 |
Ajmer | DEF | Shampoo | Deluxe Shampoo | 130 |
Ajmer | GHI | Shampoo | Deluxe Shampoo | 70 |
Ajmer | JKL | Shampoo | Deluxe Shampoo | 55 |
Udaipur | ABC | Shampoo | Deluxe Shampoo | 77 |
Udaipur | DEF | Shampoo | Deluxe Shampoo | 35 |
Udaipur | GHI | Shampoo | Deluxe Shampoo | 120 |
Udaipur | JKL | Shampoo | Deluxe Shampoo | 98 |
Jodhpur | ABC | Shampoo | Deluxe Shampoo | 80 |
Jodhpur | DEF | Shampoo | Deluxe Shampoo | 120 |
Jodhpur | GHI | Shampoo | Deluxe Shampoo | 95 |
Jodhpur | JKL | Shampoo | Deluxe Shampoo | 130 |
Jaipur | MNO | Shampoo | Premium Shampoo | 60 |
Jaipur | PQR | Shampoo | Premium Shampoo | 45 |
Jaipur | STU | Shampoo | Premium Shampoo | 40 |
Jaipur | XYZ | Shampoo | Premium Shampoo | 90 |
Ajmer | MNO | Shampoo | Premium Shampoo | 46 |
Ajmer | PQR | Shampoo | Premium Shampoo | 55 |
Ajmer | STU | Shampoo | Premium Shampoo | 30 |
Ajmer | XYZ | Shampoo | Premium Shampoo | 35 |
Udaipur | MNO | Shampoo | Premium Shampoo | 22 |
Udaipur | PQR | Shampoo | Premium Shampoo | 55 |
Udaipur | STU | Shampoo | Premium Shampoo | 15 |
Udaipur | XYZ | Shampoo | Premium Shampoo | 60 |
Jodhpur | MNO | Shampoo | Premium Shampoo | 45 |
Jodhpur | PQR | Shampoo | Premium Shampoo | 60 |
Jodhpur | STU | Shampoo | Premium Shampoo | 70 |
Jodhpur | XYZ | Shampoo | Premium Shampoo | 20 |
So segment would be in slice or in filter. I want data to be classified based on following two parameters:
Volume Contribution | Market Share | Classification of Town |
Town Contributing 80% of Volume in particular segment | >= State's Market Share | Stronghold |
Town Contributing 80% of Volume in particular segment | < State's Market Share | Headroom |
Town Contributing 20% of Volume in particular segment | >= State's Market Share | Emerging |
Town Contributing 20% of Volume in particular segment | < State's Market Share | Small |
Here State is Rajasthan so market share would of a brand in a particular segment. Each town will be classified based on their brands' volume in thier segment. I know a market share measure to be made but how do I approch this as i have 15 million rows dataset and I need help with it using DAX so that everthing would be dynamic. Any help would be appreciated.
Regards
Harish Rathore
I really tried hard to understand what you wrote but couldn't. This is probably a rather simple calculation to do but the wording and no real example obscure the whole thing...
Would you please restate the problem in simpler terms and, above all, give us some simple example?
Thanks.
Best
D
Hi @Anonymous ,
Please find link of excel file. I have tried to explain everything in the file.
Link for the file - https://chav5nz-my.sharepoint.com/:x:/g/personal/office883_chav5nz_onmicrosoft_com/EZy73DG7rFhNrNu_40JmLk8B8BPc5NlP9vd0Vbl5aDUZwA?e=pyelnl
Please do revert for any query and help me in this regards
Regards
Harish Rathore
Hi @Anonymous , I hope i have tried to explain my requirement very clearly. please do let me know if I was not clear about my query.
Regards
Harish
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 |
---|---|
45 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |