Find no of rows, with a filter, where rows have same value in one column, but different in others

[RichHead1821]

I want to achieve something akin to this (this populates a column as true if the number of rows, filtered, is > 1 where the filters in ALLEXCEPT are the same).

What I need to find now is similar, except the PolicyReference needs to be the same, but Product OR ProductType OR Term are different. I'm assuming my starting point (trying to amend this) is not a good idea, but I can't see a way to achieve what I need

hasPolicyHolderMoreThanOneSameProductWithNODifferences =

IF(

CALCULATE(

COUNTROWS(

FILTER(

factSoldCovers,

factSoldCovers[couldCoverBeEligible2022Offer1] = TRUE()

)

),

ALLEXCEPT(

factSoldCovers,

factSoldCovers[PolicyReference],

factSoldCovers[Product],

factSoldCovers[ProductType],

factSoldCovers[Term]

)

) > 1,

TRUE(),

FALSE()

)

[RichHead1821 · Accepted solution]

I did it in two stages, used the first to ID where they were the same, then checked that in a second stage

[amitchandak]

@RichHead1821 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[RichHead1821]

HI, yes, sample data would be single table (factSoldCovers):

factSoldCovers[couldCoverBeEligible2022Offer1] (true or false)

factSoldCovers[PolicyReference] (unique INT)

factSoldCovers[Product] (A, B, C)

factSoldCovers[ProductType] (1, 2, 3)

factSoldCovers[Term] (10 to 99) INT

Hope that helps, sorry it's brief I am in a meeting (all day) 😞