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?