Check if Words are different

[craftbeer]

Hi,

I am triying to use EXACT to check if Brands are different or not

I have a big table and i dont know how to check if the manufacturer in each category is unique.

I started with an old formula based on numbers and i think earlier does not belong here.

My idea is to check all the manufacturer in each category and give true or false.

column with dax = EXACT(FILTER('Tablename', 'Tablename'[Category] = EARLIER?!(Tablename[Manufacturer])))

error: EXACT needs at least two arguments i guess i need some kind of an array of all the different manufacturer for each category.

Category	Manufacturer	columns with dax
Car	BMW	true
Car	VW	true
Car	GM	true
Truck	Ford	true
Truck	MAN	true
Truck	Mercedes	true
Bus	Bus1	false
Bus	Bus1	false
Bus	Bus2	true

[amitchandak]

@craftbeer , Try a new column like

new column =
var _cnt = countx(filter(Table, [Category] = earlier([Category]) && [Manufacturer] = earlier([Manufacturer])),[Manufacturer])
return
if(_cnt =1, true(), false())

[craftbeer]

thank you @amitchandak 

it is working but i didnt understand all of it by now