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.

lbendlin's avatar
lbendlin
Super User
4 years ago

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.