It seems like a wrong model. Check if you have 1 -> N relationship between tables. Provide create statement and insert statement (for few records), so that we can test here.

did you try removing the count filter (the third filter and see if you get the records). Why there is aggregation on dimension columns. It should be for fact columns.

one of the table may be causing issue. Try removing columns other than transaction ID and check which table join is causing this. It is something with the joins and tables only. when it is getting grouped by transaction ID

what is the physical query result in DB?

Now it is very clear that you have 2 records in the db and it is displayed in the answers. and for the second issue where is the filter X_MEMBER_NUM = 'TJ-1415' in second query?

what is the result set for above two queries i posted? Also check the query which is generated when you have no records(till 31st Dec 2017).

what is the data type of expiration date?. desc table? what about first issue? is it resolved?

what is the result it fetches for select row_wid, X_MEMBER_NUM, T155106.X_PROGRAM_NAME from W_LOY_MEMBER_D where X_MEMBER_NUM = 'TJ-1415' and X_PROGRAM_NAME = 'TAPPMe' and for the below select a.member_wid as ROW_WID, a.expiration_dt as ExpirationDate, sum(a.accrualed_value) as AccruedValue, sum(a.x_used_value) as…

Check the physical query and see if you have the same data in database. Ideally it will be, Also check if your expiration date has a timestamp in DB.