How to get Class that dont have a Subclass

[zzzsharepoint]

I have following table and I would like to know how can i get a count of all the Class which dont have a Subclass

Type	Name	ParentClassName
Class	A
Class	B
SubClass	SA	B
Class	C
Class	D
SubClass	LO	C
SubClass	OP	A
Class	I

Here if you see, only Class A,B,C has subclass but others dont have a Subclass. I would like to get the number of Class which do not have a Subclass

[amitchandak · Accepted solution]

@zzzsharepoint ,

Has child =

Var _tab = summarize(filter(Table, Table[Type] = "Class"), Table[Name])

return

countx(filter(Table, Table[parent] in _tab ), [NAme])

Then have measure has no child

no child=

countx(values(Table[Name]), if(Isblank([Has child]), [Name], blank() ) )