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

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper 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
    Icon for Super User rankSuper 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.

     

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    9 years ago

    Hi

    First u have to check whether u have getting correct data from SalesLastYear , Sales

     

    Then do the calculation that will help u to understand , where u r missing .

     

    otherwise share some sample data i will help u.