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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.