Forum Discussion
Table visual rows count
Anonymous
Try with this MEASURE
Bacially try putting all the row fields inside Summarize function
MEASURE = COUNTROWS ( SUMMARIZE ( TableName[G/L Account], TableName[Customer], TableName[Assignment], TableName[Document number], TableName[Type], TableName[Posting Date], TableName[Year/Month], TableName[Year], TableName[BusA], TableName[Dos Date], TableName[Reference], TableName[PK] ) )
Community ChampionAnonymous
Try with this MEASURE
Bacially try putting all the row fields inside Summarize function
MEASURE =
COUNTROWS (
SUMMARIZE (
TableName[G/L Account],
TableName[Customer],
TableName[Assignment],
TableName[Document number],
TableName[Type],
TableName[Posting Date],
TableName[Year/Month],
TableName[Year],
TableName[BusA],
TableName[Dos Date],
TableName[Reference],
TableName[PK]
)
)
pthapaPost Patron
Hello,
I want to see how many rows are in the table visual in PBI. The measure COUNTROWS(table) will give me all the rows present in the table, which I don't want. I just want to see the total rows in the visual, how can I do that?
Thankspthapa
- rgouette
Helper II
unreal, how difficult they have made it...to just count the # of rows on a table visual...
seriously..I don't get it
MartaspgAdvocate I
You need to define a measure that count the number of distintct elements of the elements that you are using in the visual table. Try the following, for a visual table that hast N columns in it would be
COUNTROWS(GROUPBY('table'[columnA],[columnB],...,[columnN]))
