Get number of rows in Table visual

[RafaelAri]

I have a Table visual, that is based on some calculated measures.

I need a Card visual, to display the number of results (rows) in the table.

I suppose I need a mesure with a kind of "COUNTROWS", but I can't get the correct results

[Idrissshatila]

Hello @RafaelAri ,

if you mean you want the count of the table visual as per of the filters and what you see in the report, the you can create a measure that has a virtual table and you put the same columns as in the table visual and you wrapt it up with a count rows.

something like this but you adjust it with your fields

RowCountMeasure = 
VAR VirtualTable = 
    SUMMARIZE(
        Sales,
        Sales[Product],                 -- Group by Product
        "Total Sales", SUM(Sales[Amount]), -- Create a measure for Total Sales
        "Average Sales", AVERAGE(Sales[Amount]) -- Create a measure for Average Sales
    )
RETURN 
    COUNTROWS(VirtualTable)

[RafaelAri]

Thank you, but It did not solve the problem.
I'll try to open a new post, with a different characterization of the problem.

[Bibiano_Geraldo · Accepted solution]

Hi @RafaelAri ,

To display the number of rows shown in the Table visual on a Card visual, you need to create a measure that calculates the count of rows based on the same filters applied to the Table visual.

Can you share the DAX used for calculation?

You can try also something like this:

RowCount = COUNTROWS(VALUES(TableName[KeyColumn]))

[RafaelAri]

Thanks,

I tryed this solution, it gives me a big number, that is totaly not what I expect

[bhanu_gautam]

@RafaelAri , I hope you are trying using countrows like

RowCount = COUNTROWS('YourTableName')

Your process seems correct can you share sample data

[RafaelAri]

Thanks, but this gives the total rows, without the filtering

[Bibiano_Geraldo]

Can you share the sample file or sample data?
You can upload to cloud like onedrive or other and share the link for download here.

Thank you