Issue level calculations pull in any issue imported into the account. You would like to apply the filters to get a correct set of issues for each member (member combinations) used on Rows.
You are using issue properties to represent some logic. Issue properties are great for any issue level calculations. However, they do not validate if the issue is correctly counted for any pages selections on a report.
You would like to use a measure as a filter for any issue level calcualtion if you would like to get some content. The most used measure for this case is Issues created.
Here is an example, how I expanded your formula by adding a filter by measure. I left properties as only filters on the issue set. I used Sum function instead of count and added measure as a counter and it works there as a filter as well:
IsEmpty([Measures].[Issue Contract Execution Date]) OR
(DateCompare(DateWithoutTime([Measures].[Issue Contract Execution Date])
,DateParse('2018-12-31')) > 1)
-- counter by measure works as a filter as well:
The calculation didn’t work as expected, it is filter only the Issues where the ‘Issue Contract Execution Date’ is empty but it’s excluding those where the value is > 2018. So results are very low.
Can you check out the formula and help me to build one that gets those values? Thanks in advance.