Dynamic field based on subset

Hi reggiebob ,

Add the following measures to your model:

Location % = 
            DIVIDE(
			SUM(Sales[Sales]),
			CALCULATE(
				SUM(Sales[Sales]),
				REMOVEFILTERS(Customer[ShiptoCityState])
			)
		)



Site size = 
        SWITCH(
			TRUE(),
			SELECTEDVALUE(Customer[Contract]) = BLANK(), "No Contract",
			MAXX(
				ALLSELECTED(Customer[ShiptoCityState]),
				[Location %]
			) >= MIN('% Table'[% Value]), "Single Site",
			"Multi Site"
		)

Filter by site size = IF([Site size] in VALUES('Site size'[SiteSize]), 1)

Use the measures on your visuals and the Filter by size should be placed on the filter pane for the specific visual with the option is not blank.

Please see attach file.