cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RanjanThammaiah Frequent Visitor
Frequent Visitor

Calculate formula

Hi All,

 

Can any one help me to calculate the below formual. I need to divide the Growth %/ Revenue plan Growth %.

 

These two have been calculated different measure in power BI.

 

now i have to arrive the Variance by Dividing the below formula.(Growth% / Rev Plan Gr%)

 

Growth % = DIVIDE(CALCULATE(SUM('Cross Domain'[MTD_TER])-SUM('Cross Domain'[PMTD_TER])),SUM('Cross Domain'[PMTD_TER]),0)
 
Rev Plan Gr% = DIVIDE(CALCULATE(SUM('Cross Domain'[Revenue_Plan])-SUM('Cross Domain'[PFY_TER])),SUM('Cross Domain'[PFY_TER]),0)
 
Thanks,
Ranjan
3 REPLIES 3
Super User
Super User

Re: Calculate formula

Sample data and output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Calculate formula

Hi @RanjanThammaiah ,

 

Please try to use the formula. If it doesn't meet your requirement, kindly share your sample data and excepted result to me. Please upload your files to One Drive and share the link here.

 

Measure =
VAR Growth =
    DIVIDE (
        CALCULATE ( SUM ( 'Cross Domain'[MTD_TER] ) - SUM ( 'Cross Domain'[PMTD_TER] ) ),
        SUM ( 'Cross Domain'[PMTD_TER] ),
        0
    )
VAR Rev =
    DIVIDE (
        CALCULATE (
            SUM ( 'Cross Domain'[Revenue_Plan] ) - SUM ( 'Cross Domain'[PFY_TER] )
        ),
        SUM ( 'Cross Domain'[PFY_TER] ),
        0
    )
RETURN
    Growth / Rev

Regards,

Frank

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

Re: Calculate formula

Hi @RanjanThammaiah ,

 

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

 

Regards,
Frank

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