Power BI – – Use slicer selections to filter main data table

Solution for Power BI – – Use slicer selections to filter main data table
is Given Below:

I could use a bit of help. I have a main table called OAS. The key columns are Provider, Department, PctAvailable, SlotDatetimeDTS, and Tier.

I have three slicers that pull on unconnected tables I created. There is a slicer for each Tier (Low, Mid, High). Each slicer allows the end user to select a percentage(e.g., 10%, 20%, etc.).

For the OAS table, I have a measure that shows the percentage selected from the slicers that correspond to the specific Tier.

Here’s where I am getting trouble. I have created a new table call Filtered. The formula used to create the table is as follows:

Filtered = FILTER(‘OAS’, ‘OAS'[PctAvailable] >= ‘OAS'[Pct]).

However, when I view Filtered by creating a table in the report section, the Filtered table has many instances where the ‘OAS'[PctAvailable] is less than ‘OAS'[Pct].

What am I doing wrong?