Dynamic Classification with two parameters

Question

Hi,I want to classify towns based on their volume in different segment. Following is the example dataset:Town NameBrand NameCategorySegmentVolumeJaipurABCShampooDeluxe Shampoo100JaipurDEFShampooDeluxe Shampoo50JaipurGHIShampooDeluxe Shampoo40JaipurJKLShampooDeluxe Shampoo120AjmerABCShampooDeluxe Shampoo90AjmerDEFShampooDeluxe Shampoo130AjmerGHIShampooDeluxe Shampoo70AjmerJKLShampooDeluxe Shampoo55UdaipurABCShampooDeluxe Shampoo77UdaipurDEFShampooDeluxe Shampoo35UdaipurGHIShampooDeluxe Shampoo120UdaipurJKLShampooDeluxe Shampoo98JodhpurABCShampooDeluxe Shampoo80JodhpurDEFShampooDeluxe Shampoo120JodhpurGHIShampooDeluxe Shampoo95JodhpurJKLShampooDeluxe Shampoo130JaipurMNOShampooPremium Shampoo60JaipurPQRShampooPremium Shampoo45JaipurSTUShampooPremium Shampoo40JaipurXYZShampooPremium Shampoo90AjmerMNOShampooPremium Shampoo46AjmerPQRShampooPremium Shampoo55AjmerSTUShampooPremium Shampoo30AjmerXYZShampooPremium Shampoo35UdaipurMNOShampooPremium Shampoo22UdaipurPQRShampooPremium Shampoo55UdaipurSTUShampooPremium Shampoo15UdaipurXYZShampooPremium Shampoo60JodhpurMNOShampooPremium Shampoo45JodhpurPQRShampooPremium Shampoo60JodhpurSTUShampooPremium Shampoo70JodhpurXYZShampooPremium Shampoo20So segment would be in slice or in filter. I want data to be classified based on following two parameters:Volume ContributionMarket ShareClassification of TownTown Contributing 80% of Volume in particular segment&gt;= State's Market ShareStrongholdTown Contributing 80% of Volume in particular segment&lt; State's Market ShareHeadroomTown Contributing 20% of Volume in particular segment&gt;= State's Market ShareEmergingTown Contributing 20% of Volume in particular segment&lt; State's Market ShareSmallHere 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.&nbsp;RegardsHarish Rathore&nbsp;&nbsp;

anonymous · Answer

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

harishrathore · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Please find link of excel file. I have tried to explain everything in the file.&nbsp;Link for the file -&nbsp;https://chav5nz-my.sharepoint.com/:x:/g/personal/office883_chav5nz_onmicrosoft_com/EZy73DG7rFhNrNu_40JmLk8B8BPc5NlP9vd0Vbl5aDUZwA?e=pyelnl&nbsp;Please do revert for any query and help me in this regards&nbsp;RegardsHarish Rathore

anonymous · Answer

OK. Will have a look today.BestD

harishrathore · Answer

Hi&nbsp;Anonymous&nbsp;, I hope i have tried to explain my requirement very clearly. please do let me know if I was not clear about my query.&nbsp;RegardsHarish

anonymous · Answer

I have not had a chance to look at this yet. I'm at work. When back at home, I'll certainly have a look.BestD

Forum Discussion

Dynamic Classification with two parameters

5 Replies

Related content

Fabric + Purview (Data Classification)

Dynamic subcription parameter not saving

Sum dynamic parameter fields multiple selected parameter

Classification from dynamic data

dynamic parameter

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

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