Forum Discussion
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 ...
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.
