topic Fix Matrix total based on two rows in DAX Commands and Tips

Fix Matrix total based on two rows

ysherriff — Thu, 13 Oct 2022 15:03:16 GMT

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 #2, when I add a date hierarchy, the total is incorrect. Image #3 is the formula I am using.

Can anyone help? Thaks in advance

Image#1

Image #2

image #3

Re: Fix Matrix total based on two rows

tamerj1 — Thu, 13 Oct 2022 16:02:49 GMT

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 ) ) )

Re: Fix Matrix total based on two rows

ysherriff — Thu, 13 Oct 2022 16:21:46 GMT

Perfect. Works perfectly.

Thank you very much 😀