Calculation Help!

[NCPowerBI]

Hi all,

I'm new to Power BI and I'm trying to get the syntax right for the below calculation. For whatever reason, Power BI is not letting me reference previous calculated fields I have created either when I create a new column or measure, so I am stuck with stuffing all of the filters in this equation. Thanks and please let me know if you have any ideas! This is giving me errors on Curr_Amt_Fin and Fin_Prod_ID for the syntax there.

CALCULATE(SUM('Extension Data Query'[Interest Income]),'Extension Data Query'[Fin_Prod_ID] = "ZRCONT", 'Extension Data Query'[UIID_Status] = "A")*12/ (SUM('Extension Data Query'[Curr_Amt_Fin],'Extension Data Query'[Fin_Prod_ID] = "ZRCONT")

[NCPowerBI]

Thank you sir!

[MohammadLoran25]

Hi @NCPowerBI ,

I think you need this:

CALCULATE (
    SUM ( 'Extension Data Query'[Interest Income] ),
    'Extension Data Query'[Fin_Prod_ID] = "ZRCONT",
    'Extension Data Query'[UIID_Status] = "A"
) * 12
    / CALCULATE (
        SUM ( 'Extension Data Query'[Curr_Amt_Fin] ),
        'Extension Data Query'[Fin_Prod_ID] = "ZRCONT"
    )

If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.

Regards,
Loran