Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 processes a contract for the same business. I have tried creating a column but it doesn't seem to work because the values in "type of change" are in the same column Here is my data:

Date BusinessType of ChangeName of Agent
12/10/20Joe's AutoContract ReceivedJames
12/10/20Joe's AutoContract ReceivedJames
12/10/20Jack's SalonContract ReceivedJames
12/10/20Jack's SalonContract ActivatedHelen


Can anyone help me?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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)

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@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
Not applicable

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

Anonymous
Not applicable

Thank you 🙂

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors