Duplicate Identifier

[Anonymous]

Good morning, I hope you can help me.

I want to identify the value of duplicator products by Price $ / kWh.

From the measure I did, it identifies all of them as duplicates but it does not show me the non-duplicates, if someone could help me

[truptis]

Hi @Anonymous ,

Please try this:

Count_duplicates =
Var a= [Price $ / kWh]
RETURN

CALCULATE(
COUNTROWS('TableName'),
all('TableName'),
'TableName'[Price $ / kWh] = a
)

whereever the count_duplicates is greater than 1 it means there are duplicate values.

@Anonymous -> please hit the thumbs up & mark it as a solution if it helps you. Thanks.

[Anonymous]

@truptis