How to get Class that dont have a Subclass

Question

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&nbsp; &nbsp; &nbsp;Type&nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ParentClassName&nbsp;&nbsp; &nbsp; &nbsp; Class&nbsp; A&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; Class&nbsp; &nbsp;B&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; SubClass&nbsp; &nbsp;SA&nbsp; &nbsp; &nbsp;B&nbsp;&nbsp; &nbsp; &nbsp; Class&nbsp; &nbsp;C&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; Class&nbsp; &nbsp;D&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; SubClass&nbsp; &nbsp;LO&nbsp; &nbsp; &nbsp;C&nbsp;&nbsp; &nbsp; &nbsp; SubClass&nbsp; OP&nbsp; &nbsp; &nbsp;A&nbsp;&nbsp; &nbsp; &nbsp; Class&nbsp; &nbsp; &nbsp;I&nbsp;&nbsp;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 Answer

zzzsharepoint , 
Has child =
Var _tab = summarize(filter(Table, Table[Type] = "Class"), Table[Name])
return
countx(filter(Table, Table[parent] in _tab ), [NAme])
&nbsp;
Then have measure has no child
no child=
countx(values(Table[Name]), if(Isblank([Has child]), [Name], blank() ) )

Forum Discussion

How to get Class that dont have a Subclass

1 Reply

Related content

Class not registered error

Show classes required and taken

Balanced accuracy for multi-class

Dynamic calculating balanced accuracy for multi-class

ArcGIS Map not updating class min/max values automatically

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