Forum Discussion
How to make custom column using sub-category count
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 |
4 Replies
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] )
Not Matching with "Expected Count using Category From A cloumn"
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 ??
