Get Average in a measure by using a filter

Hi Community,

I have a table visual that has two measures called Rev per hour 1 and Rev per hour 2. As seen below in the last line of the table it gives a total average of 1018 for Rev_per_hour 1 and 1265 for Rev_per_hour_2. But I also have a filter applied to this table visual, Rev_per_hour 2 is not blank, which reduces the number of customers, and changes the outcome.

I have also created a multiple card using the same measures Rev_per_hour 1 and Rev_per_hour 2, unfortunately, you cannot filter the card on Rev_per_hour 2 to get the same result as you did in the table visual.

If you don't use the filter on Rev_per_hour 2, then both the card visual and the table visual would have the same result.

Is there a way to change both measures so that you can add a filter inside both measures where it says Rev_per_hour 2 is not blank?

Here are both measures:

rev_per_hour1 = DIVIDE([xxxrev1],[xxxrev1.0],BLANK())

rev_per_hour2 = DIVIDE([xxxrev2],[xxxrev1.0],BLANK())