cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SR1 Regular Visitor
Regular Visitor

Measure 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:

Capture.JPG

 

 

I am using date dimension for the date slicer.

 

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Measure not in sync with slicers

Also:

 

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


7 REPLIES 7
Super User
Super User

Re: Measure not in sync with slicers

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Super User

Re: Measure not in sync with slicers

Also:

 

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


SR1 Regular Visitor
Regular Visitor

Re: Measure not in sync with slicers

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

 

 

Super User
Super User

Re: Measure not in sync with slicers

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


SR1 Regular Visitor
Regular Visitor

Re: Measure not in sync with slicers

Tried but still facing the same issue.

Super User
Super User

Re: Measure not in sync with slicers

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


SR1 Regular Visitor
Regular Visitor

Re: Measure not in sync with slicers

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.