When you have an aggregate measure as a filter, it's going to do the work at whatever dimensional level you have on the sheet.
If you want to chop out hospitals based on the measure -- no matter what level is displayed on the sheet, consider making the slider on a parameter, and then you can create a calc to include hospitals that meet the criteria.
Do you need help doing that? Or is that good enough to get you going?
Good morning Taylor
see the attached
the formula I used is
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hospital List_v10.2.JDtwbx.twbx 17.6 KB
if you select 346 as the min value, Detroit still have one hospital with 352. But if you remove Hospital Name from the hierarchy , Detroit disappear in the IDN.
Anyway, you are overcomplicating things, no need for lod in this case. You already have the Hospital # of beds at the row level, so you just have to drag [# of Staffed Beds] on the filter shelf, but select All values instead of an aggregation.
Hospital List(mc).twbx 39.3 KB