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
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!