Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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.   ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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

  • Pragati11's avatar
    Pragati11
    6 years ago

    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

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

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