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
8 years ago

HelloGreg_Deckler

By this measure how can count Total no of rows in the visual.

Cant tack directly becouse of  tack sum of Amount balance column (group by), so some no of rows in excel sheet  get minimize the count then visual table.

want to show table visual count of rows.

Regards ,
Pooja

 

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi Anonymous

    Yes, it can display on a card chart.

    Measure = COUNTROWS(Sheet1)

    If you have 10 rows in the excel, when import to Power BI, your table shows 10 rows, then the function "COUNTROWS" will count all rows of your table despite you use any aggregation in the column.

    But if the number of rows in the excel is 8, then the table in Power BI shows 8 rows, you can't get more than 8 using "COUNTROWS" 

     

     

    Best Regards

    Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi v-juanli-msftIf the number of rows in the excel is 8, then the table in Power BI shows 8 rows, you can't get more than 8 using "COUNTROWS" - Yes i kown , thats the issue i want to consider aggregate function and then count the rows .

      If  the number of rows in excel is 8 import data in power bi Rows are 8 fine ,when we aggregate its less then 8,
      hope you unstustand 

      Pooja


      .