Adding column with counting rows by different categories

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