Forum Discussion

GoncaloCare's avatar
GoncaloCare
Helper I
5 years ago
Solved

Calculate Marketshare - Help

Hi. I need some help building a table with marketshare values. So, imagine I have this table:   Year-Month Brand Value Jan'21 A 45 Jan'21 B 35 Jan'21 A 76 Jan'21 C 465 ...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, GoncaloCare 

Please check the below picture and the sample pbix file's link down below.

 

 

Percentage by month =
IF (
ISFILTERED ( 'Calendar'[Year-Month] ),
DIVIDE (
SUM ( Data[Value] ),
CALCULATE ( SUM ( Data[Value] ), ALLSELECTED ( Brands[Brand] ) )
)
)

 

 

https://www.dropbox.com/s/czwzog2rny4zypo/goncalocarre.pbix?dl=0 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: https://www.linkedin.com/in/jihwankim1975/

GoncaloCare's avatar
GoncaloCare
Helper I
5 years ago

Hi again Jihwan_Kim !

 

So, it's working great! 

I have a question. In the line chart, I have 188 Brands, but only like 30/50 are showing. Do you know why that is happening? is that a limitation?

 

Thanks!

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, GoncaloCare 

    Thank you for your feedback.

    I am not sure about how is the limitation of showing how many categories (or legends) in a linechart.

    I also sometimes face a similar situation as what you just described.

    However, if I see over 20 lines in one line chart, I don't think it creates values or insights for readers. Or, perhaps you can try to select other visualizations, like a scatter chart for instance, if you need to show more than 20~30 categories.

    Thank you.

    • GoncaloCare's avatar
      GoncaloCare
      Helper I
      5 years ago

      Hi Jihwan_Kim 

      Thank you very much again. Sadly, it doesn't show all brands. Do you know any way to group brands? For example, in the table I provided, grouping A and C to "Other" group. 

      Is it possible?

       

       

      Thanks!

      Best Regards.

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi, GoncaloCare 

        Thank you for your feedback.

        If you just want to group those two, you can simply create a hierarchy table.

        Or, do you want to dynamically group? For instance, below 50% goes to "Others", and shows the rest? This is also doable if you have a rule about how to group those.

        If it is OK with you, please share your sample pbix file's link here, and give instructions about how to group. Then I can try to look into it to come up with a more accurate solution.

         

        Thank you.