cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User IV
Super User IV

Re: Market Share in Respective Category

Attached here.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Highlighted
Frequent Visitor

Re: Market Share in Respective Category

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]),

CALCULATE([Volume],

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])),

CALCULATE([Volume],ALL(ProductMaster)))

 

Is it right? I am not getting 100% when i am manually calculating market share of brands. Kindly help.

 

Regards

Harish Rathore

Highlighted
Super User IV
Super User IV

Re: Market Share in Respective Category

Hi,

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted
Frequent Visitor

Re: Market Share in Respective Category

Thanks @Ashish_Mathur  for your solution. Its perfectly working with my requirements.

 

Thanks again. Kudos to you.

 

Regards

Harish Rathore

Highlighted
Super User IV
Super User IV

Re: Market Share in Respective Category

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors