Slicer value not filtering a calculated table

[newhopepdx]

I've uploaded a demo here: https://www.dropbox.com/scl/fi/5jeb08dod0trcjzjokl4p/Demo.pbix?rlkey=bdukbk88rft7sw9leocjtxxrw&st=bv...

Have created a calculated table that lists customers with a count of the number of purchases they have made.

I want that to be filtered to only customer with # of purchases >= the selecedvalue of the purchase count slicers.

But CustomersWithPurchases table isn't filtering properly.

[How Many] measure is:    How Many = SELECTEDVALUE(Purchases[PurchaseCount])

Here's the table creation code:

CustomersWithPurchases =

FILTER(

    SUMMARIZE (

            Invoices,

            Invoices[CustomerID],

            Customers[Customer],

            Customers[Region],

            "Purchase_Count", COUNT(Invoices[CustomerID])),

    [Purchase_Count] >= [How Many]

    )

[HotChilli · Accepted solution]

slicers don't affect calculated tables. These tables are created at refresh time and don't change

[newhopepdx]

Bummer!

Thanks