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?
I have tried creating two cards one for each measure, unfortunately, it doesn't work.
Yes, a measure needs to be created where it says Rev_per_hour 2 is not blank? Can you create a measure that will give me the desired result and will match the table visual, if so how can I write this measure?