Duplicate Value

[Anonymous]

Good afternoon, what I want to do is identify the duplicates regarding the product, for example, tell me that the values ​​($/kwh price) that product 1 has are duplicates, that is, the price of product 1 is duplicated

I want you to tell me how many price duplicates product 1 has and so on with the other products.

But the measure throws me all the products as duplicates

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, I have created a simple sample:

Please try:

Measure = 
var _a = CALCULATE(COUNTROWS(FILTER(ALLSELECTED('Table'),[Producto]=MAX('Table'[Producto])&&[OFERENTE]=MAX('Table'[OFERENTE])&&[OFERTA]=MAX('Table'[OFERTA])&&[Precio]=MAX('Table'[Precio]))))
return IF(_a>1,"SI","NO Hay Empate")

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Read about filter context.  Do not use SELECTEDVALUE inside a CALCULATE.  Do not use ALL unless absolutely necessary (use ALLSELECTED instead). Using FILTER inside of CALCULATE is overkill.  Read about using variables to protect values from context transitions.