Forum Discussion

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

Large Table Visual that Needs Filtering on RowCount

I have a large table visual where the source is 2M+ rows.  I want to filter the table where only the first 25,000 will appear in the table.  I have a secondary table filter named InDateRange that is ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi _power_bi ，

Try combining two filters together using a sequential structure.

Like:

 

topN Filter = IF( [InDateRange] = 1, RANKX(ALLSELECTED('Table'), CALCULATE(SUM('Table'[Value])),,DESC,Dense))

 

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group