Forum Discussion

JaouadZrhibi's avatar
JaouadZrhibi
Icon for Helper I rankHelper I
7 years ago

Market share issue - Distribution over a single year

Hi,   I have tried different measures but I cant see the distribution over a single year.   My formula calculate the market share for all years from 2001 till 2018 but how to do it for only one y...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi JaouadZrhibi,

 

Here we go.

 

Market Share2 = 
var minyear = MIN(Period[Year]) 
var maxyear = MAX(Period[Year])
var Direction = SELECTEDVALUE(Details[Direction])
return 
DIVIDE(CALCULATE(SUM([Tons])),CALCULATE(SUM([Tons]),FILTER(ALL(Details),Details[Year]<=maxyear&&Details[Year]>=minyear && Details[Direction]=Direction)))

Regards,

Frank

JaouadZrhibi's avatar
JaouadZrhibi
Icon for Helper I rankHelper I
7 years ago

I find figures above 100 % like on the pictures.

 

Is it normal ?

 

 

Regards,

 

Jaouad