Count Rows based on Columns

[Sam70]

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

[amitchandak · Accepted solution]

@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))

[Sam70]

Hi @amitchandak ,

I made a mistake. Used your formula in a new table and it worked perfect.

Thank you

Regards

[Sam70]

Hi @amitchandak ,

No idea about the error. Guide me.

Regards