Slicer value not filtering a calculated table

Question

I've uploaded a demo here:&nbsp;https://www.dropbox.com/scl/fi/5jeb08dod0trcjzjokl4p/Demo.pbix?rlkey=bdukbk88rft7sw9leocjtxxrw&amp;st=bvz088ur&amp;dl=0&nbsp;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 &gt;= the selecedvalue of the purchase count slicers.But CustomersWithPurchases table isn't filtering properly.&nbsp;[How Many] measure is:&nbsp; &nbsp;&nbsp;How Many = SELECTEDVALUE(Purchases[PurchaseCount])&nbsp;Here's the table creation code:CustomersWithPurchases =FILTER(&nbsp; &nbsp; SUMMARIZE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Invoices,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Invoices[CustomerID],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Customers[Customer],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Customers[Region],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Purchase_Count", COUNT(Invoices[CustomerID])),&nbsp; &nbsp; [Purchase_Count] &gt;= [How Many]&nbsp; &nbsp; )

hotchilli · Accepted Answer

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

Forum Discussion

Slicer value not filtering a calculated table

2 Replies

Related content

Calculating with Filters

Slicer for filtering several columns

Time Filter Slicer

Calculate Filters

Filter data using slicer