Forum Discussion

dd88's avatar
dd88
Post Patron
2 years ago
Solved

count rows with same value in the one column

I have a column Department, that contains all the organisation departments eg  Deparment Finance Adminstration Client Services HR Board HR HR Finance Finance Finance Technology how c...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    In Power Query, create another tables with the unique departments.  Create a relationship (Many to One and Single) from your Fact tables to the new tables.  To a Table visual, drag Department from the new table.  Write this measure

    Count = countrows(Data)

    Hope this helps.

  • muhammad_786_1's avatar
    muhammad_786_1
    2 years ago

    Hy dd88 
    You can get your desired output by this simple measure.

     

     

    Best Regards,
    Muhammad Yousaf

     

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

     

    Follow on LinkedIn

dd88's avatar
dd88
Post Patron
2 years ago

thank you bhanu_gautam 

 

The result is a total departments ie 9

 

I would like to count the total of each department in the 1 column eg using the above data

Department column

Adminstration = 1

Board = 1
Client Services = 1

Finance = 4

HR = 2

Technology = 1

 

TIA

 

 

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

In Power Query, create another tables with the unique departments.  Create a relationship (Many to One and Single) from your Fact tables to the new tables.  To a Table visual, drag Department from the new table.  Write this measure

Count = countrows(Data)

Hope this helps.