How can I make this calculated column dynamic with multiple slicers?

[PA7177]

Hi

I use this calculated column to calculate days between entries. I want to calculate days between when there are multiple slicers.  It works with the ID slicers but not anything else. Any ideas?

With ID slicer works fine

Does not work with my category slicer

Days Between =

VAR temp =

    TOPN (

        1,

FILTER (

            'Time Stamp',

            'Time Stamp'[ID] = EARLIER ( 'Time Stamp'[ID] )

                && 'Time Stamp'[Occurrence] < EARLIER ( 'Time Stamp'[Occurrence] )

        ),

        [Occurrence], DESC

    )

RETURN

    DATEDIFF ( MINX ( temp, [Occurrence] ), 'Time Stamp'[Occurrence], DAY )

Thanks

[Anonymous]

Calculated columns are only updated when you refresh the dataset. You would need (and probably should anyway) covert this to a measure. 

[PA7177]

The reason I used a calculated column is because I would always get an error with the measure using the exact same DAX.

---

---

[Anonymous]

The concept of earlier doesnt exists if you take your calculated column logic and directly apply to a measure. You can use earlier in a measure with some additiona logic, but probably easier to just add an index to your table so you have a concept of what is previous. You can do that using a calculated column, or better yet power query. can you upload some sample data?

[PA7177]

This is what my data looks like.

Sliced by ID without category slicerSliced by ID with category slicer. Does not count days properly.