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

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.