Filter and dax formula

Hi, GraceTCL 

According to your description and sample pictures, I can clearly understand your meaning, and I think the AllExcept() function can perfectly help you to achieve the expected output, you can transform the measure like this:

This is the test data I created based on your picture:

Sum of revenue =

CALCULATE(SUM(Sales[Revenue]),ALLEXCEPT(Sales,Sales[Date],Sales[Vertical]))

Then I created three slicers and a card chart to make a test:

And you can get what you want.

More info about the AllExcept() function in DAX

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.