How to make custom column using sub-category count

[ukantkumar123]

I need to make custom coumn using "Category From A" count ?? ( Last column is expected coumn )

Please have a look on table !!

Category From A	Sub-Category From Table A	Sub-Category Used  From Table B	User Name from Table B	Expected Count using Category From A
Soil Investigation	Tesing	Tesing	Rock	1
Foundation	Open Foundation
Foundation	Pile Foundation
Substructure	Pier
Substructure	Pier Cap	Pier Cap	Rock	2
Substructure	Pier Cap	Pier Cap	Terry	2
Superstructure	Girder	Girder	Terry	1
Superstructure	Girder	Girder	Samson	1
Superstructure	Bearing	Bearing	Terry	1
Superstructure	Bearing	Bearing	Sanju	1

[amitchandak]

@ukantkumar123 , create a new measure like

countx(filter(allselected(tableA), TableA[Sub-Category] = max(TableA[Sub-Category] ) ), TableA[Sub-Category] )

or new column in Table A

countx(filter(tableA, TableA[Sub-Category] = earlier(TableA[Sub-Category] ) ), TableA[Sub-Category] )

[ukantkumar123]

Not Matching with "Expected Count using Category From A  cloumn"

[ukantkumar123]

@amitchandak @ta

Basically i have 2 table "TableA" and "TableB"

"TableA" data is fixed only TableB data filled by user.

Now I have Joined the table using "Sub-Category" Since it is a commnon on both the table

Now i need to count the based on "category" , "Sub-Category" and "User Name"

Cause For same category , for Sub-Category "user" can feed the data .



A kind of Group by Count ??

[Anonymous]

Hi @ukantkumar123 ,

I'm still a little confused. 

Why do you get different values in the same case? Why the column Sub-Category From Table A also should be counted even if it is blank? 

Please provide more details with the desired output.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.