Straight Table how to add one more column for count number of row ?

[Paulyeo11]

Hi All

I have below table , i like to add one more column it will display 1 on every row , and i can sum up this column , so that i know this table have how many row.

https://www.dropbox.com/s/s0zmu80qoyioghq/PBT_V01038%20count%20number%20coy%20at%20table.pbix?dl=0

Above is my PBI file .

Paul

[amitchandak · Accepted solution]

@Paulyeo11 , I doubt there is dynamic row counter for table. Please log a new idea- https://ideas.powerbi.com/ideas/

You have create a column like

Countrows(summarize(Table, Table[Company], Table[Group_]))

[amitchandak]

@Paulyeo11 , I think distinctcount of company. File attached after signature

[amitchandak]

@Paulyeo11 , Are you looking for distinctcount(Table[Brand])

[Paulyeo11]

Hi Amit

What i need is count number of row on the striaght table. for example i have below table , which compute which are the new account in 2021 ? and i like to add one more column to display count number of row.

Paul

[amitchandak]

@Paulyeo11 , Nor clear Any one of the two measures

Measure= calculate(countrows(Table))

or
Measure=  calculate(countrows(Table),allselected(Table))

[Paulyeo11]

Hi Amit

I try using youe expression , i get 23 , which is wrong , how to get 8 ?

https://www.dropbox.com/s/781a9g77rklb267/PBT_V01038%20count%20number%20coy%20at%20table.pbix?dl=0

Above link is my PBI file

Paul