Different Calc Results

[biuser431]

Hi All - I seem to be getting different results using the same filter critieria in the following functions - I'm basically trying to count open invoices on the last day of a month in a new summary table. My source data has 2 columns I'm using to filter - Advanced Date and Paid Date : 

This function gives me the correct value of open invoices: 

EOM Open Invoices = COUNTROWS(FILTER(ALL('Data'),

        'Data'[Advanced Date]<(EOMONTH('Summary'[YearMonthShort],0)+1) &&

        OR(ISBLANK('Data'[Paid Date]),'Data'[Paid Date]>(EOMONTH('Summary'[YearMonthShort],0)))))

This function gives me an incorrect value omitting several values that should properly be included:

EOM Open Invoices = CALCULATE(COUNT('Data'[Advanced Date Day]),FILTER(ALL('Data'),

        'Data'[Advanced Date Day]<(EOMONTH([YearMonthShort],0)+1) &&

        OR(ISBLANK('Data'[Paid Date Day]),'Data'[Paid Date Day]>EOMONTH([YearMonthShort],0))))

Trying to understand the difference? 

[Anonymous]

Hi  @biuser431 ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous]

Hi @biuser431 ,

As checked the formula of the above these measures, I found that there are some conditions which applied on the formulas are different between them (Please check the below screenshots). I'm not sure if it cause the result of the second measure is incorrect... By the way, is there any blank values in the field 'Data'[Advanced Date Day]?

[Advanced Date] and 'Data'[Paid Date]

[Advanced Date] and 'Data'[Paid Date][Advanced Date Day] and 'Data'[Paid Date Day]

Best Regards