Forum Discussion

JacktheYeti's avatar
JacktheYeti
Helper I
5 years ago
Solved

Measure is causing incorrect Grand Total

I'm using the following measure to calculate the total Cost per Unit allocated: 'Total $ Amount = SUM('Campaign'[CostPerMasterKey]) * SUM('RPT_CampaignOrderMasterKeyCounts'[TotalMasterKeysCount])' ...
Need Help
  • FrankAT's avatar
    FrankAT
    5 years ago

    Hi JacktheYeti 

    your formula should read:

     

    Total $ Amount = SUMX('Campaign', 'Campaign'[CostPerMasterKey] * RELATED('RPT_CampaignOrderMasterKeyCounts'[TotalMasterKeysCount]))

     

    if both table have an active relationship.

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi JacktheYeti 

your formula should read:

 

Total $ Amount = SUMX('Campaign', 'Campaign'[CostPerMasterKey] * RELATED('RPT_CampaignOrderMasterKeyCounts'[TotalMasterKeysCount]))

 

if both table have an active relationship.

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

  • JacktheYeti's avatar
    JacktheYeti
    Helper I
    5 years ago

    This did the trick, thanks very much. I'll need to read up on the RELATED and SUMX functions.

     

    Warm regards,

    Jack