Trying to Count Total Number of Rows that ignores one filter but not the rest of the filters

[Wkeith]

Basically, I have a count function that is trying count rows based on two slicers. One slicer is a date slicer and the other is a product category slicer. I want to ignore the product category slicer but keep the date slicer for the count. Therefore, for example, I am counting all products between two dates (lets say 1/1/2019 and 6/30/2019) even when a user selects a specific product from the other product category slicer. 

I have two tables. One that I am counting transactions, FactSales, and one with dates that is connected to FactSales, DimDate. 

Current forumla: 

Count Test = CALCULATE(COUNT(FactSales[RevenueRecognitionDate]),ALLEXCEPT(dimdate,DimDate[DateKey]))

However, this formula gets filtered by the product category filter on my dashboard therefore retuning only that specfic categories sales for that time period instead of returning all products in that time period. 

I want to ignore the product category slicer but still filter for the date range slicer.

Let me know if you can help! 

[Cmcmahan · Accepted solution]

You're naming the wrong table in your ALLEXCEPT.

You don't want all the data from the dimDate table except keeping what's filtered by the date slicer, you want all the data from the FactSales table, except keeping what's filtered from the date slicer.

Count Test = CALCULATE(COUNT(FactSales[RevenueRecognitionDate]),ALLEXCEPT(FactSales,DimDate[DateKey]))