Cumulative Measures messing with Date Sliders

[paulcar]

The idea is to have the cumulative data not be affected even when the start date of the slider is past the entry date of the data.

Super confused. Ive been on this for hours and hours.

[MFelix]

Hi @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

[paulcar]

Hey @MFelix ,

Here's the project file:

https://videohusky-my.sharepoint.com/:u:/p/paul_cardenas/EcT2Azr85hZIkc0E62Q1LTIB_AB0kS5bZrXd1zIgscy...

removed the sensitive data so some charts wont be working right.

[MFelix · Accepted solution]

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

[paulcar]

Hey @MFelix ,

Thanks for your interest. How do I share a sample exactly?