Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Identifying ISSAME

Hi guys,   Needing some help trying to make a measure to identify when a name in one column is linked to two separate values in another.   I want to quantify when an Agent both receives and proce...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Did no see ant processed row.

    You need to have column like


    if(calculate(distinctcount(Table[Type of Change]), filter(Table, [Name of Agent] = earlier([Name of Agent]) && [Type of Change] in {"Received","processes"}
    && [Date] = earlier([Date]))) =2, 1,0)

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Did no see ant processed row.

You need to have column like


if(calculate(distinctcount(Table[Type of Change]), filter(Table, [Name of Agent] = earlier([Name of Agent]) && [Type of Change] in {"Received","processes"}
&& [Date] = earlier([Date]))) =2, 1,0)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sorry, I actually realised this is not the solution.

 

I meant to say I need to find usernames who have both Contract Received and Contract Activated.

 

I tried to adjust the column but the results returned do not correctly show Business names where both the same agent received and activated the contract