Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Helper V
7 years ago

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
General Comment
Interesting Links
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      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