Showing results for 
Search instead for 
Did you mean: 
siobhanforsdick Frequent Visitor
Frequent Visitor

Get Data from COUNTROWS Measure



I have some KPIs set up as Card visualisations, with the results being a COUNTROWS measure based on a SQL query. Is there any way to see from this the rows that the query produces? I know I could use the Edit Queries feature, but I was hoping for something based within the dashboard itself.



Community Support Team
Community Support Team

Re: Get Data from COUNTROWS Measure

hi, @siobhanforsdick

After my research, I'm afraid it couldn't achieve in Power BI for now.

and you may try to use Drill through function in your report.

For example:

Assume we have two reports, A and B. we set the B as the focused page. we can right-click on a data point in A and drillthrough to B to get details that are filtered to that context.

So you could do one or more pages report for the detailed information set drill through for it.


For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.



Best Regards,


Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.