DAX Measure is giving same result for each matrix row.

[GabFort]

I have tried making a measure to calculate my net new clients from the last month (outputing a 1 if the earliest open date was within the month preceding the month selected in a slicer). Here is my current dax measure 

DYNAMIC Client net new = 
VAR SelectedDate = MAX(dimCalendar[Date])
VAR YearSelected = YEAR(SelectedDate)
VAR MonthSelected = MONTH(SelectedDate)
VAR StartOfLastMonth = IF(
    MonthSelected = 1,
    DATE(YearSelected - 1, 12, 1),
    EOMONTH(SelectedDate, -2) + 1
)
VAR EndOfLastMonth = IF(
    MonthSelected = 1,
    EOMONTH(DATE(YearSelected - 1, 12, 1), 0),
    EOMONTH(SelectedDate, -1)
)

RETURN
IF(
    NOT ISBLANK(SelectedDate),
    SUMX(
        FILTER(
            dimCurrentMatter,
            CONTAINSSTRING(dimCurrentMatter[MatterNumber], "00001") &&
            dimCurrentMatter[OpenDate] >= StartOfLastMonth &&
            dimCurrentMatter[OpenDate] <= EndOfLastMonth &&
            YEAR(dimCurrentMatter[OpenDate]) = if(MonthSelected=1,YEAR(TODAY())-1, YEAR(TODAY()))
        ),
        1
    ),
    BLANK()
)

It is giving me the accurate number but when I try to add the measure to a matrix, it gives the exact same number for each row and a total of the same number as well. I tried using the summarize function, addcoluns instead of sumx, calculate, etc. I can get the accurate number multiple different ways but it never sticks when in a visual. 

[Greg_Deckler · Accepted solution]

@GabFort So typically this indicates a missing relationship between 2 tables. 

[GabFort]

Is there a way to workaround that at all ? I'm working with a dataset I cannot change and there is indeed not a direct relationship between the table where the opendate is found and the table where the office is found. 

[Greg_Deckler]

@GabFort Possibly. You could grab the MAX of the office or office ID or whatever. You would need something in your fact table that specified what office was involved. You would then add an additional clause to your FILTER statement ( && ). 

That's about as specific as I can get without more information.

[GabFort]

Fair ! I cannot add anything to the fact tables used in the model so will need to speak to the model owner before making further progress. Thank you for your answer.