Forum Discussion
Solved
First User Touch
I am trying to determine the first user to touch an account and to exclude any automate touches. For example, below is my data. For account 1, the first user should be Bob and for account 2, the firs...
PowerBI123456 , Try a new measure like
measure = calculate(sum(Table[Index]), filter(Table,Table[Index] = calculate(max(Table[Index]), allexpcept(Table,table[Account]), table[Activity] <> "Automate")))
amitchandak Looking at the index. First user who has the greatest index per account and that user cannot be "automate". Does that help?
PowerBI123456 , Try a new measure like
measure = calculate(sum(Table[Index]), filter(Table,Table[Index] = calculate(max(Table[Index]), allexpcept(Table,table[Account]), table[Activity] <> "Automate")))