Forum Discussion

wwii's avatar
wwii
Frequent Visitor
9 years ago
Solved

Calculate Marginal Ratio in PowerBI

Hi,

 

I wonder is there any quick way to calculate a marginal profit ratio, i.e. (x-y)/x

in PowerBi?

 

Thank you and I appreciate.

 

Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi wwii, could you not create 2 calculated measures.


    One calculated measure for X, and another calculated measure for Y?


    And then you can create your 3rd calculated measure which will be as per your example (x-y)/x

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi wwii, could you not create 2 calculated measures.


    One calculated measure for X, and another calculated measure for Y?


    And then you can create your 3rd calculated measure which will be as per your example (x-y)/x

    • wwii's avatar
      wwii
      Frequent Visitor
      9 years ago

      I used this formula,

       

      YoY% = var Sales = SUM(SalesTable[Amount])
      var SalesLastYear=CALCULATE(Sales, SAMEPERIODLASTYEAR(Calenda[Date]))
      return if(Sales, DIVIDE(Sales - SalesLastYear, Sales))

       

      But the outcome is all 0.

       

      Is there is a way to know why?

       

      Thanks

      • BhaveshPatel's avatar
        BhaveshPatel
        Super User
        9 years ago

        What do you meany by this:

         

        if(Sales, DIVIDE(Sales - SalesLastYear, Sales))

         

        Why do you need to use measure in the first argument.