Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Table visual rows count

Hello , you got any solution for adding sr. no in table visual , I stuck with same probleam like i want to show total number of rows in the table visual but for some column i used aggregate function...
General Comment
Interesting Links
Need Help
Tutorial Requests
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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]
    )
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

You should just be able to create a measure like:

 

MyCount = COUNTROWS('Table')

or maybe

MyCount = COUNTROWS(CALCULATETABLE('Table'))
Anonymous's avatar
Anonymous
Not applicable
7 years ago

if the visual involves multiple tables data....this wont work..so how do we get count of rows in visual that is sourced from multiple tables and multiple filters? should we create a another kpi visual which will show count of rows and apply same fileds and filters?