Filter table on duplicate values

[mikegrattan]

I've got the following formula that shows me if a check number is duplicated, but now I want to filter the table to show only those checks that are duplicates.  Please advise.  Thank you.

=If(count(TOTAL <CheckNo> CheckNo)>1,1,0)

[stevejoyce · Accepted solution]

For on-the-fly calculation of duplicate (i.e. taking our selections in to account) use below.

convert to a calculated dimension using aggr, you can move this to set analysis as well:

When you select 1, it will select the combination of fields in your aggr(), so in the below it will select the CheckNos that have duplicates.

=alt(aggr(count(distinct{<CheckNo= {"=count(CheckNo) > 1"}>} 1), CheckNo),0)

If you can/want to have it based on entire data set, you can create your duplicate flag in the data model as a field, with count / groupby.

[mikegrattan]

This works perfectly, thank you!

[stevejoyce]

@mikegrattan  great!  please mark solution so post can be closed and marked appropriately.