Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Duplicate Identifier

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

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • truptis's avatar
    truptis
    Community Champion
    4 years ago

    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.