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

[Anonymous]

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 

[v-diye-msft]

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]

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 )

[Greg_Deckler]

I am not clear on the requirements. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490