Forum Discussion
SR1
Helper I
8 years agoMeasure not in sync with slicers
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!
Also:
CountVal1 = CALCULATE ( COUNTROWS ('Sample'), ALLEXCEPT ('Sample','Calendar'[Date], 'Sample'[Name] ) )
7 Replies
- Greg_Deckler
Community Champion
Also:
CountVal1 = CALCULATE ( COUNTROWS ('Sample'), ALLEXCEPT ('Sample','Calendar'[Date], 'Sample'[Name] ) ) - Greg_Deckler
Community Champion
Dumb question, is your Date dimension related to your fact table?
- SR1
Helper I
Yes. Other measures created on this fact table are in sync with the slicers.
- Greg_Deckler
Community Champion
Right, see my second response, you need to ALLEXCEPT your date dimension, not your fact table for the date at least.