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.
GoncaloCare , Try a measure like
divide(sum(Table[Value]), calculate(sum(Table[Value]), filter(allselected(Table),Table[Year-Month] = max(Table[Year-Month]))))
or
divide(sum(Table[Value]), calculate(sum(Table[Value]), removefilters(Table[Brand])))
Hi! Thank you very much! I will try that solution, and If I need any assistance, I'll reply again. Thanks!