Forum Discussion
Adding column with counting rows by different categories
Hello,
Can you please support me how to add the green column in the example below, starting from table A & B:
The expected column should contain the total number of companies by class.
Thanks and BR.
Anonymous , if table A can act as a master table means has a unique company id. Join to on company Id. Else create common dimension of company and calss and analyze data count(TableB[Class]) againt the common dimesnions
Hi Anonymous ,
You can create a relationship between Table A and Table B on "Company ID" column.
Then on a table visual, move P.Line, Class and COUNT(Company ID).
You will get the desired result.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
2 Replies
Anonymous , if table A can act as a master table means has a unique company id. Join to on company Id. Else create common dimension of company and calss and analyze data count(TableB[Class]) againt the common dimesnions
Hi Anonymous ,
You can create a relationship between Table A and Table B on "Company ID" column.
Then on a table visual, move P.Line, Class and COUNT(Company ID).
You will get the desired result.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati