Get and add a column with sum of all the duplicate values(from another column)

[smandadi]

Each WO2 has multiple sequential station id's with checkoutdates. I need to only show the WO2's which have station id "1" in them. For this, I created DAX to show 1 if row has station 1 and 0 if it doesn't.
I want to sum the _hasid1 column and display as a column on right so that I can slicer the values that have sum(_hasid1)>0. But I keep getting random values when I sum it up.

Here is the code I used. 

Appreciate any help.

[Anonymous]

Hi @smandadi 

The Earlier function is mostly used in the context of calculated columns, not in mersure.
Reference post: Solved: EARLIER functionality in Measure - Microsoft Fabric Community

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smandadi]

Both are created as columns. I mistyped it as measure, I corrected it now.