Limiting Rows in a Visual to 500k

Hi SurajManghani 

You cannot rely on counting the rows in a table because this may not reflect the actual number of rows shown in the visual. Instead, the DAX query used in the visual needs to be replicated.

The table below uses this DAX formula to get the number of rows:

Number of Rows in the visual = 
VAR _tbl =
    SUMMARIZECOLUMNS (
        'Category'[Category],
        'Category'[sort],
        'Dates'[Date],
        'Geo'[Geo],
        "Total_Revenue", [Total Revenue]
    )
RETURN
    COUNTROWS ( _tbl )

Create this measure as warning text to be used in a card

Warning = 
IF (
    [Number of Rows in the visual] > 1000,
    "More than 1,000 rows are visible. Use the slicers to reduce the number of rows so the data can be displayed.",
    "The table contains " & [Number of Rows in the visual] & " rows."
)

Use this measure as a visual filter

Visual Filter = 
VAR _limit = 1000
RETURN
    IF ( CALCULATE ( [Number of Rows in the visual], ALLSELECTED () ) <= _limit, 1 )

Please see the attached pbix.