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'))
pthapa's avatar
pthapa
Post Patron
1 year ago

Hello Greg,
I wanted to see  the total rows present in the table/matrix visual not the entire rows present in the model.

Example, I have a table visual with Customer No 1001,1002,1003 with their sales, now when you put them in the table visual, there are only 3 rows present in the visual. But if I use the dax COUNTROWS(), this will give me the count of rows for the entrie model for specific customer No, which I don't want. I want to show only 3 since I have only 3 rows in the visual. 
Hope this make sense. Can you please help.
Thanks,

pthapa