The Customer table contains fields such as Name, Address, and customer Number.
The Order Date table is a standard date dimension with fields like Order Date and Month, Year.
The Sales Order Fact table includes details like Order Amount, Quantity, and other transaction-level data.

The report includes multiple visuals — such as cards, tables, bar charts, and several slicers.

I want to implement a filter where:

If the user selects "> 100", the report should display data only for customers whose total order amount is greater than $100.

If the user selects "≤ 100", the report should show data only for customers whose total order amount is $100 or less.

This filter should apply across the entire report to all visuals consistently.