Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Duplicate Value

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 produ...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-jianboli-msft's avatar
    v-jianboli-msft
    4 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
4 years ago

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.