I have a dataset which is well modelled. I am trying to get brands market share in their respective brands; following are measures which i have already created;
SUM ( SalesData[Depletion] )
'ProductMaster'[Segment Short Desc],
'ProductMaster'[Operating Segment Y/N],
'ProductMaster'[Parent Product Type]
IFERROR ( [Volume] / [Segment Vol], BLANK () )
|Volume My Company||=|
CALCULATE ( [Volume], ProductMaster[Company Short Name] = "My Company" )
|My Company MS%||=|
IFERROR ( [Volume My Company] / [Segment Vol], BLANK () )
everything is working fine the only thing is when I am putting my company's brand in Table in power bi and select volume and market share measures then i should be getting market share % of a brand in their respective segment and not market share of total segment vol. Please help me in this regards.
Solved! Go to Solution.
Share some data and show the exact result that you are expecting.
Hi @Ashish_Mathur , Kindly find sample data and expected result;
Town NameBrand NameCategoryCompanySegmentVolume
|Jaipur||ABC||Shampoo||My Company||Deluxe Shampoo||100|
|Ajmer||ABC||Shampoo||My Company||Deluxe Shampoo||90|
|Udaipur||ABC||Shampoo||My Company||Deluxe Shampoo||77|
|Jodhpur||ABC||Shampoo||My Company||Deluxe Shampoo||80|
|Jaipur||MNO||Shampoo||My Company||Premium Shampoo||60|
|Ajmer||MNO||Shampoo||My Company||Premium Shampoo||46|
|Udaipur||MNO||Shampoo||My Company||Premium Shampoo||22|
|Jodhpur||MNO||Shampoo||My Company||Premium Shampoo||45|
|Jaipur||ABCD||Shampoo||My Company||Prestige Shampoo||120|
|Ajmer||ABCD||Shampoo||My Company||Prestige Shampoo||70|
|Udaipur||ABCD||Shampoo||My Company||Prestige Shampoo||80|
|Jodhpur||ABCD||Shampoo||My Company||Prestige Shampoo||130|
My Company's performance -
so market share should be in respective segments.
If you do not want to frag Brand in the visual, then refer to this file.
Hope this helps.
Hi @Ashish_Mathur , I am not able to download both of your files. Have tried to download on Chrome, IE and Edge.
Can you please share some other sources or links to download the file.
Thanks @Ashish_Mathur for your solution. Its perfectly working with my requirements.
Thanks again. Kudos to you.
Hi @Ashish_Mathur , Thanks for your solution. Its perfectly working fine, but i do have one query; in measure of "Total volume of segment" you have placed ALL(Data) at the end of the measure. I have one "SalesData" and one "ProductMaster" table in my model, my measure is like this :
IF(HASONEVALUE(ProductMaster[Brand Short Desc]),
FILTER(ALLEXCEPT(ProductMaster,ProductMaster[Segment Short Desc],ProductMaster[Operating Segment Y/N],ProductMaster[Parent Product Type]),
VALUES(ProductMaster[Segment Short Desc])=[Segment of the Brand])),
Is it right? I am not getting 100% when i am manually calculating market share of brands. Kindly help.
Please share your exact data structure/layout/tables. WIthout all information, i cannot help. Share your PBI file with dummy data but with the relevant tables so that i can offer a working solution. Be very clear of which fields from which tables do you want to drag into the final table/matrix visual.
You may download my PBI file from here.
Hope this helps.
Hi @HarishRathore25 ,
1. Create a measure for Total Volume
2. Create a measure for Volume by Brand.
Hi @HarishRathore25 ,
Also, One more way incase you want to show it in a table.
Goto Relationship view and create a new Hierarchy.
Did I answer your question? Mark my post as a solution!
Please appreciate with a kudos
Hi @harshnathani , Thanks for your efforst but do i have to select segment name as well in order to get market share %?
Also, i only want to select my company's brand, volume and market share. See, i want to have a view of target vs actual and along with that i need to show market share of those brand only. by doing this i will be able to show perfromance dashboard.
Dear @HarishRathore25 ,
Since the use ws not very clear, it really provides value to inform viewers about the Brand name and the Segment Market Share. Also, since you are using measures, you will need to use the segment name as the data is filtered by both brand and segment name as the data is filtered based on this.
Nevertheless, if you do not want to include the Segment Name, here is what you can do.
1. Create Calculated Column: