get count of table when filter pane used

[lgroger]

I have a table that is being filtered with the filter pane.  The field used as a filter is a measure which is why it has to be applied to the table itself in the filter pane.  As far as I know, it's not possible to use a measure as a slicer and it won't let me add the meaure as a filter to the entire page.

I would like to show a card with a row count of the table but it's currently not reflecting what's being filtered out by the filter pane.  Any help would be greatly appreciated! 

[V-lianl-msft · Accepted solution]

Hi @lgroger

Based on your description, you need to use the first measure as the filter of the second measure to display the results you want. You can try to use the DAX below:

Measure 2 = CALCULATE(COUNTROWS(table),FILTER(table,[Measure1]))

Best Regards,

Liang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly