Forum Discussion

_power_bi's avatar
_power_bi
Icon for Helper I rankHelper I
2 years ago
Solved

Top N visual filter issue with large table

I have a wide table with 1M+ rows.  The end user wants to display as many rows as possible in a simple table visual. I want to display the first 25,000 rows.  If the number of rows returned is more t...
  • rajendraongole1's avatar
    2 years ago

    Hi _power_bi - Create a DAX measure that calculates the row number for each row by using below measure:

    RowNumberInRange =
    CALCULATE(
    COUNTROWS(FILTER(coupon_details, coupon_details[InRange] = 1)),
    FILTER(
    ALLSELECTED(coupon_details),
    coupon_details[ID] <= MAX(coupon_details[ID])
    )
    )

     

    This above measure calculates the row number for each row where [InRange] = 1, while preserving the filter context for other columns.

    Create another measure to checks if the row number is less than or equal to 25,000 to returns 1 otherwise 0

     

    FilteredRows =
    IF([RowNumberInRange] <= 25000, 1, 0)

     

    apply the filtered rows on the visual level filter in your table chart and set it 1. It works . please check with your conditions 

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!