Forum Discussion

likmalik's avatar
likmalik
Icon for Helper I rankHelper I
5 years ago
Solved

Calculate Marketshare over 12months.

Hello,   I am trying to display the marketshare for various models over time and am struggling with which DAX formula to use. I have a simple table (country, brand, model, units sold, date). I wou...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, likmalik 

     

    You can modify the measure:Add [Date]=SELECTEDVALUE(Sheet1[Date])

    VAR total =
    SUMX (
        FILTER ( ALLSELECTED ( Sheet1 ), [Date] >= startdate && [Date] <= enddate&& [Date]=SELECTEDVALUE(Sheet1[Date]) ),
        [Sales numbers]
    )
VAR single =
    SUMX (
        FILTER (
            Sheet1,
            [Date] >= startdate
                && [Date] <= enddate
                && [Model] = SELECTEDVALUE ( Sheet1[Model] )
                &&[Date]=SELECTEDVALUE(Sheet1[Date])
        ),
        [Sales numbers]
    )

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, likmalik 

 

I shared the sample In the reply above,You can download and only modify two variables in my old measure.

 

Best Regards

Janey Guo

likmalik's avatar
likmalik
Icon for Helper I rankHelper I
5 years ago

It works thank you so much!

4 days that I tried on different forums but no-one was able to help me. You are the king of powerBI. 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi,  likmalik 

     

    Glad to help you. If I can get kudos, I will also be very happy.😁

     

    Best Regards

    Janey Guo

  • likmalik's avatar
    likmalik
    Icon for Helper I rankHelper I
    5 years ago

    Done v-janeyg-msft  ! Last question : How do you generate the tables (End Month, End year, Start Month Start Year) because I'm trying to integrate your solution into my main file not the sample file I gave you and if I only copy the measure it says that tables are missing.