- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Count Rows based on Columns
Hi,
Below is table data in PowerBI (Desktop)
I want to create another table where data should be like
Being very new to BI, unable to generate the required output. Need help.
Regards
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Sam70 , In a table visual you can use a measure
countrows(Table)
Or can use count of any column
If you need calculated column, you can use Summarize
Summarize(Table, Table[Track], Table[ParameterA], Table[Account ID], Table[MonthName], Table[Customer Name], "Count", countrows(Table))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Sam70 , In a table visual you can use a measure
countrows(Table)
Or can use count of any column
If you need calculated column, you can use Summarize
Summarize(Table, Table[Track], Table[ParameterA], Table[Account ID], Table[MonthName], Table[Customer Name], "Count", countrows(Table))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @amitchandak ,
I made a mistake. Used your formula in a new table and it worked perfect.
Thank you
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
07-18-2024 04:42 PM | |||
09-04-2024 10:26 PM | |||
03-15-2024 07:44 AM | |||
07-15-2024 10:00 AM | |||
07-30-2024 01:07 PM |