Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Profit Margin %

Hi All,

I am calculating Profit Margin % and it shows same value for All segments. When I filter through Year shows same value. I have attached the same. Please assist me on this to get the correct value. ,, 

Show and Tell

13 Replies

  • dharmendars007's avatar
    dharmendars007
    Icon for Memorable Member rankMemorable Member
    1 year ago

    Hello Anonymous , 

     

    The measure what you shared looks correct but here are few checks you can do..

     

    1. Please check if your date table is mapped to the datatable..

    2. Kindly use Calculate once to cross check if there is any filter context missing

     

    Margin % =
    DIVIDE(
    CALCULATE(SUM('SalesTable'[Revenue])),CALCULATE(SUM('SalesTable'[SalesAmount])),0)

     

    If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

     

    Thank You

    Dharmendar S

    LinkedIN 

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi,

      There is no seperate Revenue column & SalesAmount.

      Columns are:
      ProductID, Date, CustomerID, CampaignID, Units, Product, Category, Segment, ManufacturerID, Manufacturer, Unit Cost, Unit Price, ZipCode, Email, Name, City, State, Region, District, Country

  • elitesmitpatel's avatar
    elitesmitpatel
    Icon for Solution Supplier rankSolution Supplier
    1 year ago

    Try this 

    Profit Margin % =
    DIVIDE(
    SUM(SalesTable[Profit]),
    SUM(SalesTable[SalesAmount])
    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      There is no profit column in my dataset.

      Columns are:


      ProductID, Date, CustomerID, CampaignID, Units, Product, Category, Segment, ManufacturerID, Manufacturer, Unit Cost, Unit Price, ZipCode, Email, Name, City, State, Region, District, Country

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi, Anonymous 

         

        Can you provide some of the example data from your dataset? If it is sensitive data, you can simulate some of it. How is Total sales obtained?

         

        Best Regards,

        Community Support Team _Charlotte

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    I calculate revenue and Total COGS as attached. Then I calculate Margin %,

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, Anonymous 

       

      I simulated some data and your formula but failed to restore your problem.

      Can you tell us more details about your data?

       

      Best Regards,

      Community Support Team _Charlotte

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

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

         

        Thi si the moddelling I have done