Measure not in sync with slicers

[SR1]

Hi,

I have created a measure that counts the number of rows based on Date & Name column.

However the measure is not getting changed according to the slicer selection. Please help me find the issue.

Here is my code:  

CountVal = CALCULATE ( COUNTROWS (Sample), ALLEXCEPT (Sample,Sample[Date], Sample[Name] ) ) 

Sample table:

I am using date dimension for the date slicer.

Thanks!

[Greg_Deckler · Accepted solution]

Also:

CountVal1 = CALCULATE ( COUNTROWS ('Sample'), ALLEXCEPT ('Sample','Calendar'[Date], 'Sample'[Name] ) ) 

[Greg_Deckler]

Dumb question, is your Date dimension related to your fact table?

[SR1]

Yes. Other measures created on this fact table are in sync with the slicers.

[Greg_Deckler]

Right, see my second response, you need to ALLEXCEPT your date dimension, not your fact table for the date at least.

[SR1]

Tried but still facing the same issue.

[Greg_Deckler]

Hmm, mine seems to work like a champ. See attached.

[SR1]

Thank you so much! It works now! I was using DateId column instead of Date column in my measure. But my slicer was using date column.