Calculations on Calculated Table

[PBrainNWH]

Any way to create calculations on this table? I need to divide the Donations by the # fields.

Donations by Customer by FY =

SUMMARIZE(

    'Opportunity Contact Role',

    'Opportunity Contact Role'[ContactId], Contact[Full_Name_with_Nickname__c],'Opportunity Contact Role'[Role],

    "2023 Donations", CALCULATE(SUM('Opportunity Contact Role'[Amount__c])+0, 'Opportunity Contact Role'[Close_Date__c] >= DATE(2022, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] <= DATE(2023, 6, 30)),

    "2024 Donations", CALCULATE(SUM('Opportunity Contact Role'[Amount__c])+0, 'Opportunity Contact Role'[Close_Date__c] >= DATE(2023, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] <= DATE(2024, 6, 30)),

    "2025 Donations", CALCULATE(SUM('Opportunity Contact Role'[Amount__c])+0, 'Opportunity Contact Role'[Close_Date__c] >= DATE(2024, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] <= DATE(2025, 6, 30)),

    "2023 # of Donations", CALCULATE(COUNT('Opportunity Contact Role'[Close_Date__c])+0,'Opportunity Contact Role'[Close_Date__c] >= DATE(2022, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] < DATE(2023, 7, 1)),

    "2024 # of Donations", CALCULATE(COUNT('Opportunity Contact Role'[Close_Date__c])+0,'Opportunity Contact Role'[Close_Date__c] >= DATE(2023, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] < DATE(2024, 7, 1)),

    "2025 # of Donations", CALCULATE(COUNT('Opportunity Contact Role'[Close_Date__c])+0,'Opportunity Contact Role'[Close_Date__c] >= DATE(2024, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] < DATE(2025, 7, 1))

)

I need to be able to divide Donations by # (ex. 2023 Donations/2023 # of Donations)

I can't seem to find the appropriate syntax to do this on my calculated table. 

[rajendraongole1 · Accepted solution]

Hi @PBrainNWH - Can you please share some sample data for reference with expectations.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!