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]
    )
)
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous

As Greg_Deckler said, the measure can calculate the total rows of the table depite some column you used aggregate function like sum.

 

However, the total value can't show at the top of the table.

 

Best Regards

Maggie

Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-juanli-msft

Thanks for Reply,

Want to show on Card visual.

Pooja

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    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]
    )
)
    • pthapa's avatar
      pthapa
      Icon for Post Patron rankPost Patron
      2 years ago

      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?
      Thanks

      pthapa

      • rgouette's avatar
        rgouette
        Icon for Helper II rankHelper II
        1 year ago

        unreal, how difficult they have made it...to just count the # of rows on a table visual...

        seriously..I don't get it

    • Martaspg's avatar
      Martaspg
      Icon for Advocate I rankAdvocate I
      2 years ago

      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]))