Matrix total row not showing correct sum for measure value column - Active Customers per month

[Anonymous]

Hi all,

I am trying to show in a matrix visualization  active customers by year/month.  If you notice the total row for each month is not showing the sum of all active accounts, value 1 (measure) will show if that account was active through the dates it was active (startdate-enddate).

This is the measure:

MeasureEOM = if(max('Table'[EOM]),int(1),BLANK())

Where 'Table'[EOM] is the column on my table that that has the End of month date per day that the account is active.

The visualization looks like this:

This is how data looks in the table:

Thank in avdvance for your help.

[Stachu]

can you share the sample (with the sensitive data masked) from Table?

here is an example:How to Get Your Question Answered Quickly 

[Anonymous]

I added how the table looks.  Thank you.