Forum Discussion

kalpesh07's avatar
kalpesh07
Frequent Visitor
2 years ago
Solved

DAX

Hi All, I need help with DAX Formula to calculate Market Share. I've Master Data which is very clean but is a combination of Value & Volume by Segment,Manufacturer, Brand at MONTH Level. - Basic...
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI kalpesh07,

    Perhaps you can try to use the following measure formula if it suitable for your requirement:

    formula =
DIVIDE (
    SUM ( MarketData[Sales Value] ),
    CALCULATE (
        SUM ( MarketData[Sales Value] ),
        ALLSELECTED ( MarketData ),
        VALUES ( MarketData[SEGMENT] ),
        VALUES ( 'Calendar'[Date] )
    ),
    0
)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI kalpesh07,

Perhaps you can try to use the following measure formula if it suitable for your requirement:

formula =
DIVIDE (
    SUM ( MarketData[Sales Value] ),
    CALCULATE (
        SUM ( MarketData[Sales Value] ),
        ALLSELECTED ( MarketData ),
        VALUES ( MarketData[SEGMENT] ),
        VALUES ( 'Calendar'[Date] )
    ),
    0
)

Regards,

Xiaoxin Sheng

  • kalpesh07's avatar
    kalpesh07
    Frequent Visitor
    2 years ago

    Anonymous Thanks!

  • kalpesh07's avatar
    kalpesh07
    Frequent Visitor
    2 years ago

    Hi Anonymous Can you help me with the same Measure but calculating the same as rolling period. I need help with Calculating on Rolling period Basis. MAT means last 12 Month.
    So I've to calculate Sales% basis Last 12 month for every month like

    Jan'24 MAT (Feb23-Jan24)
    Feb'24 MAT (Mar23-Feb'24)
    Mar'24 MAT (Apr23-Mar24)

    • NILU090's avatar
      NILU090
      Helper II
      1 year ago

      i have a question, why did you use following statement, it may have filtered from Filter from Page.

      VALUES ( MarketData[SEGMENT] ),
      VALUES ( 'Calendar'[Date] )