Measure to count info based on 2 columns

Hi RichOB 

Use Below DAX 

Behalf_of_Someone_else =
COUNTROWS (
FILTER (
'Tickets',
NOT ISBLANK ( 'Tickets'[On_Behalf_Of] )
&& 'Tickets'[Submitted_By] <> 'Tickets'[On_Behalf_Of]
)
)

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

Hi RichOB, Hope you are doing well!

You can achieve this with the help of DAX Measure, Please use the formula below:

Behalf_of_Someone_else =
IF (
NOT ISBLANK ( TableA[On_Behalf_Of] )
&& TableA[On_Behalf_Of] <> TableA[Submitted_By],
1,
0
)

If this post helps to answer your question, please consider accepting it as a solution so others can find it more quickly when they face a similar challenge.

Proud to be a Microsoft Fabric community super user

Let's Connect on LinkedIn
Subscribe to my YouTube channel for Microsoft Fabric and Power BI updates.