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,

 

Please check the formula again.

 

Market Share = 
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[Direction]=Direction)))

 

Regards,

Frank

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

Hi v-frfei-msft

 

It looks good, I m going to do some test.

 

If we want to see the market share on 2 years / 3 years or 10 years, can we get 100% for each one ?

 

For example, 2 years = 2016 and 2017 = 100% market share

 

3 years = 2013 + 2014 + 2015 = 100% market share

 

10 years = from 2009 till 2017 = 100% market share

 

Do we have to change all formula ? If it is too difficult, it is not necessary. 

 

One year is really good.

 

I m sorry for disturbing you Frank.

 

Thank you very much for your help and time !!

 

Jaouad

 

 

 

 

 

v-frfei-msft wrote:

Hi JaouadZrhibi,

 

Please check the formula again.

 

Market Share = 
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[Direction]=Direction)))

 

Regards,

Frank

 

  • 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

    • 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