Count occurrence in a column that doesnt happen in another

[Anonymous]

Hello there,

I'd like to count how many times a value is shown in the Partner column as long as it doesn't appear in the Customer column. I've tried using something akin to that, but has not worked:

CALCULATE(COUNTROWS('Base name'), 'Base name'[Partner] <> 'Base name'[Customer])

Perhaps the reason on why this measure has not worked is the relationship between tables, however even using USERELATIONSHIP('Dimension table'[Name of the client], 'Fact table'[Partner]) I got nothing. In the example of the image, the table is a Fact type table, and its active relationship is between the Customer and another column from a dimension table.

Any thoughts on where I'm doing wrong?

P.S.: In this table, my customer can be a partner as well.

[philouduv]

Hey @Anonymous ,

In your Dimension 'Dimension table'[Name of the client] write : 

test = CALCULATE(COUNTROWS('Base name'),

Filter(ALL('Base name'),

'Dimension table'[Name of the client] == 'Base name'[Patner]

&&

'Base name'[Patner] <> 'Base name'[Customer]))

Best regards,

[Anonymous]

Thanks, my friend

[amitchandak · Accepted solution]

@Anonymous , You should use a partner from the dimension. this should work

CALCULATE(COUNTROWS('Base name'),filter( 'Base name',  'Base name'[Partner] <> 'Base name'[Customer]) )

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Thank you. It indeed worked 🤙