Forum Discussion
Cumulative Measures messing with Date Sliders
Hi paulcar ,
I was looking at the Count of editors (assume this is a cumulative calculation based on syntax).
Change it to:
Count of Editors = CALCULATE( DISTINCTCOUNT('EDITOR CLIENT DATA'[Editor Ref]);'EDITOR CLIENT DATA'[Editor Ref]<>BLANK(); FILTER( ALL('EDITOR CLIENT DATA'); 'EDITOR CLIENT DATA'[DATE] <= MAX('EDITOR CLIENT DATA'[DATE])))Looking at my tests when I change the date slicer it remains the same value always however when I do the measure like this it gives me 12 instead of 11.
Can you check in your model if it works properly?
Regards,
MFelix
Super UserHi paulcar ,
I was looking at your video, and saw that one of your measures as a ALLSELECTED(Date) in this case try to use ALL() function.
can you share a sample of your data file? If sensitive send it trough private message.
Regards,
MFelix
Hey MFelix ,
Here's the project file:
https://videohusky-my.sharepoint.com/:u:/p/paul_cardenas/EcT2Azr85hZIkc0E62Q1LTIB_AB0kS5bZrXd1zIgscyqOg?e=XZlKEL
removed the sensitive data so some charts wont be working right.
- MFelix
Hi paulcar ,
I was looking at the Count of editors (assume this is a cumulative calculation based on syntax).
Change it to:
Count of Editors = CALCULATE( DISTINCTCOUNT('EDITOR CLIENT DATA'[Editor Ref]);'EDITOR CLIENT DATA'[Editor Ref]<>BLANK(); FILTER( ALL('EDITOR CLIENT DATA'); 'EDITOR CLIENT DATA'[DATE] <= MAX('EDITOR CLIENT DATA'[DATE])))Looking at my tests when I change the date slicer it remains the same value always however when I do the measure like this it gives me 12 instead of 11.
Can you check in your model if it works properly?
Regards,
MFelix