In my dataset, I have several date columns. So I created a Calendar to make relationships with the dates. Since I can only make 1 date that is active relatoinship, I created inactive relationships with the other dates. Then I used dax Userrelationship formula to make measures to sum the $ total and reference the calendar date and my data table dates.
I used conditional formatting in my matrix table to check if the invoice has been made, then color the background of the $ amount to be green.
I have a date filter that the user can use to see when the invoices were made or will be made.
Without any date filters used, the matrix table looks correct. However, when a date is selected, the green background formatting doesn't work. It only works for the 1 date that I have an active relationship with the Calendar table. All ther other columns do not work correctly.