DAX Measure in PBI

[Anonymous]

Hi I have this table:

I need a measure to tell me how many of the concatenate fields are the same in the table.

for example, the concatenate field "1A" is two times in the table (one for Source "Red" and other with "Green". So the measure needs to indicates that the count is 2.

In the other hand, the concatenate 4E only appears 1 time, so the result of the measure is 1.

Which is the best way to build the measure?

Thanks

[amitchandak · Accepted solution]

@Anonymous , you can have measure like these and use that

Measure = calculate(count(Table[Name]), allexcept(Table, Table[Name]))
Measure green = calculate(count(Table[Name]), allexcept(Table, Table[Name]), filter(Table,Table[source]="Green"))