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

Hi v-frfei-msft

 

I would like to know if this formula below is good for the Market Share measure :

 

Market Share =
DIVIDE (
    CALCULATE ( SUM ( [Tons] ) );
    CALCULATE (
        SUM ( [Tons] );
        FILTER (
            ALL ( 'Details' );
            YEAR ( Details[Date] ) IN VALUES ( Period[Year] )
                && Details[Direction] IN VALUES ( Details[Direction] )
        )
    )
)