Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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_]))
@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_]))
@Paulyeo11 , I think distinctcount of company. File attached after signature
@Paulyeo11 , Are you looking for distinctcount(Table[Brand])
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
@Paulyeo11 , Nor clear Any one of the two measures
Measure= calculate(countrows(Table))
or
Measure= calculate(countrows(Table),allselected(Table))
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
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |