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 hav...
Need Help
Show and Tell
Tips and Tricks
v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity 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 )