Filter by Not In State

You should describe the problem more accurately so that we can give you more valuable suggestions.

Hi Anonymous , Could you please share more details that will better discribe your issue, for us to help you solve it.

Thank you.

Hi Anonymous , Please let us know if your issue is solved. If it did, please share the details here and mark it 'Accept as solution' to assist others with similar problems. If it did not, please provide further details.
Thank you.

Hi Anonymous , could you please share more details with us to help solve your issue. If it is already solved, please share the answer here and mark it 'Accept as Solution', so others with similar queries may find it easily.
Thank you.

Hi Anonymous, what about this:

Before

After (excluded 1st floor and 2nd floor)

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUXIvyi/NS1FIy8nPL1KK1YlWcgIKGhaXIIk4A0WMUNS4AEWMi5BFXIEiJiUZSCJu2Ax3xzDcA8NwTwzDvVANjwUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, State = _t]),
    FIlteredOut1stAnd2nd = Table.SelectRows(Source, each not List.Contains({"1st floor", "2nd floor"}, [State]))
in
    FIlteredOut1stAnd2nd

Hi Anonymous , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.