Forum Discussion

ysherriff's avatar
ysherriff
Resolver II
3 years ago
Solved

Fix Matrix total based on two rows

Hi, I am having difficulty coming with a formula to correct my totals in a table with multiple rows. As an example, in image #1, this is the correct total with only one value in the Row.  In Image #...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi ysherriff 

    please try

     

    =
SUMX (
    SUMMARIZE ( Campaigns, Campaigns[Campaign Name], 'Date'[Year], 'Date'[Otr-Yr] ),
    CALCULATE (
        SELECTEDMEASURE (),
        CROSSFILTER ( Campaigns[Contact ID], 'Contacts Table'[Contact ID], BOTH )
    )
)

     

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi ysherriff 

please try

 

=
SUMX (
    SUMMARIZE ( Campaigns, Campaigns[Campaign Name], 'Date'[Year], 'Date'[Otr-Yr] ),
    CALCULATE (
        SELECTEDMEASURE (),
        CROSSFILTER ( Campaigns[Contact ID], 'Contacts Table'[Contact ID], BOTH )
    )
)

 

ysherriff's avatar
ysherriff
Resolver II
3 years ago

Perfect. Works perfectly.

 

Thank you very much ðŸ˜€