Filter on conflicting dimensions

[jono19872002]

Hi

I am trying to setup a DQ report to show where there are conflicting dimensions accross different records.

The simplest example that i can think of is, for example where the same customer has been entered with different gender accross multiple records.

What formula can i use to filter down just on the customers where there are different genders in this example?

[Or · Accepted solution]

Count(Distinct WhateverDimensionIsDuplicated) > 1

Perhaps?