Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create a calculated column based on duplicated values in another column (Using Dax only)

Greeting all , 

 

i have this table in power BI   (this is just a small example so i can use it later on the project )  : 

i want to create a calculated column named "duplicate" where it have the value "1" to only one offer from the duplicated value in the table using Dax 

here is my output : 

i made some research and i think it should be created with a function called All except but i cant figure it out 

 

Thanks in advance all 

 

 

 

 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi Anonymous 

     

    Not quite understand your logic, would you like to get below results?

     

    Measure = var a = CALCULATE(MIN('Table'[Number of aplies]),ALLEXCEPT('Table','Table'[Title]))
Return
IF(MAX('Table'[Number of aplies])=a,1,0)

     

     

     

    Or this one:

    Column = var a = [Title] 
var b =  RANKX(FILTER('Table',[Title]=a),[Number of aplies],,ASC)
return IF(b=1,1,0)

    Pbix attached.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for your reply , but your solution works only if i dont have the same number of applies for every title 

       

      what im trying to acheive here is to create a column where i can use it later to filter my table without showing duplicated values of my title ! 

       

      the object here that im trying to dislay a table in my report where i show the list of the titles (i need to remove the duplicate values here just for the visual )