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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi dd88 

 

Have you solved your problem? If so, could you please mark the helpful replies as Answered to close this topic and that can help other members find it faster?

If not, could you please share your data(exclude sensitive data), or create some sample data, and your target outcome, so that we can help you better.

Thank you very much for your kind cooperation.

 

Best Regards

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