Count Rows in Visual

Hi BrianNeedsHelp 

You would need to do something like this:

1. Create a measure that constructs a table containing the same columns/measures as the matrix visual, and counts the rows.
2. Place that measure on a card visual and ensure the same slicers are filtering both the matrix and card. 

Explanation:

• Matrix visuals generate queries using SUMMARIZECOLUMNS behind the scenes, which you can capture and examine using Performance Analyzer (see here).
• With default settings, the number of rows in a matrix (and returned by SUMMARIZECOLUMNS) depends on the combinations of row fields for which at least one measure is nonblank in at least one column.
• To create your row count measure, you can take the SUMMARIZECOLUMNS component of the query and simplify/modify to produce the number of rows you actually need, depending whether you want to include subtotals etc. Then count the rows of the resulting table.

Simple example (PBIX attached):

• Assume we have a matrix containing Country and Brand on rows, and Sales Amount as the only measure.
• The matrix does not include subtotals or grand total.
• We can then create this measure to count the rows and display on a card visual:

Matrix Row Count - Country|Brand|Sales Amount = 
COUNTROWS (
    SUMMARIZECOLUMNS (
        'Product'[Brand],
        Customer[Country],
        "Sales Amount", [Sales Amount]
    )
)

Notes:

• The measure assumes specific row/column/measure fields are used in the visual.
• This would need to be modified if subtotal rows are to be included or if fields are placed in columns rather than rows.

Regards