Forum Discussion
Top N visual filter issue with large table
- 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!!
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!!