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] )
        )
    )
)

 

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi JaouadZrhibi,

     

    Just use the new measure in the visual, now shuold be ok. Please find the pbix attached. Also your formula worked well. You can refer to the third page.

     

     

    Regards,

    Frank

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

      We neen only one Market Share Measure for all widget on the same page, isn't it ?

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

      We need only one Market Share Measure for all widget on the same page, isn't it ?