Forum Discussion
Helper IIIVisual Row Count of a table
Hi,
is there a possibility to count rows of a table with applied filters from filters section (visual level filters)? no matter what measure im writing, it ignores the set filters... :(
One can drag a field into "page level filters" section so both measure (in form of a card) and the table are affected, but the problem is, I want to filter with a measure and it's not possible to drag a measure into page level filters.
Any ideas?
3 Replies
jthomsonSolution Sage
The visual level filters are, oddly enough, applied just to that visual in question - so they're not going to apply to somewhere else you want to do a countrows of. You could of course try to do something like calculate(countrows(yourtablename),[yourmeasure]=whatyourmeasureneedstobe)
eniXI know it makes totally sense that visual level filter only applies to it's visual - just trying to solve my issue.
I can't really use my filter in a measure, because "whatyourmeasureneedstobe" is set by the report consumer dynamically, while he/she analyse the data.
Any other possibility I get the row count for such a table? Maybe through totals in some way?
