I have three tables in my Power BI model:

• Sales Order Fact

• Order Date

• Customer

All these tables are properly connected.

I’ve created a few DAX measures based on them:

1. Number of Customers with Order amount > $100

2. Number of Customers with Order amount ≤ $100

The amounts are grouped Year-to-Date (YTD). So if the user selects August, the total amount is calculated from January 1st to August 31st.

All calculations are working correctly. However, I now need to create a slicer to allow users to filter between "> $100" and "≤ $100". This is where I'm stuck.

I created a measure-based flag, but I have to manually apply the filter to each visual — and this report has many visuals. Also, I’m unable to apply the measure as a filter on Card visuals, which is a limitation.

Is there any alternative approach to creating a slicer that dynamically filters visuals based on "> $100" or "≤ $100" orders?

Expected output 

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.