Forum Discussion

dd88's avatar
dd88
Icon for Post Patron rankPost 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

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

dd88 , You can create a measure using below 

 

DepartmentCount = COUNTROWS(VALUES(DepartmentsTable[Department]))
  • dd88's avatar
    dd88
    Icon for Post Patron rankPost 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
      Icon for Super User rankSuper 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.

    • muhammad_786_1's avatar
      muhammad_786_1
      Icon for Solution Supplier rankSolution Supplier
      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