The expected output is to add a coulumn to the right of Flag column with Count of distinct locations in these 4 days which are not having atleast having one Flag=1 and also show the Pie Chart with Location and dimension and Measure as this Count. In this example expected to count Location is 1 as C only satisfies this condition.
Looking for the set analysis expression which would solve this. Furhter complcation is that the date range is derived by a variable which will define the number of days in the date range, like 4 days, 5 days, 10 days.
