Running total measure not filtering with slicer

[sparkplug93751]

Hi,

 I have a running total measure that counts the first occurences of a name:

total = calculate(count(table[name]),table[occurencecheck]=1,filter(all(table),table[date]<=max(table[date])

I have a column titled location to see where everyone works, but the running total doesn't filter

Any help is appreciated, thanks

[parry2k · Accepted solution]

@sparkplug93751 change ALL to ALLSELECTED in your measure

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡