Forum Discussion
Calculate Marketshare - Help
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.
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.
Hi Jihwan_Kim
Thanks again for your help!
I would love it would be possible to dynamically group. Like, if it's above 1% MS, group into "Others.
I'm sending the raw data (I changed the names of the brands).
Here is the link https://www.dropbox.com/s/jk3wnttwec8jevn/testeee.pbix?dl=0
Hi, GoncaloCare
I am not sure whether I understood your question correctly.
I assume you want to group less than 1% into Others, right?
Please check the link down below.
Please also check the Brands Table -> I created "Others" as index number 128.
https://www.dropbox.com/s/ox56wrttiyyzb2w/testeee.pbix?dl=0
Hi Jihwan_Kim
You are amazing! Thank you so much, this is perfect! You really helped me!
Kudos for you!
Best regards!