Fix Matrix total based on two rows

DAX DAX Calculations
1

Fix Matrix total based on two rows

8 seconds ago

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? Thanks in advance

Image#1

image
image932×528 49.5 KB

Image #2

image
image910×436 31.6 KB

Image #3
image

2

Here is the solution for anyone else. I will add in Analyst Hub.

SUMX (
SUMMARIZE ( Campaigns, Campaigns[Business Segment of Interests], Campaigns[Campaign Name],
‘Date’[Year], ‘Date’[Qtr-Yr]
),
CALCULATE (
SELECTEDMEASURE (),
CROSSFILTER ( Campaigns[Contact ID], ‘Contacts Table’[Contact ID], BOTH )
)
)

I am using Tabular Editor. You can just switch SelectedMeasure() with your measure.