Forum Discussion
Get Count of Rows for Table Visual
Hello,
I have a table of Group IDs that has columns from various tables. There are slicers on the page that affect this table visual, as well as measures that further filter the table.
I want to get the count of rows for this table, but I am unsure of how to do this. If I use a basic count, I only get the count of IDs based on the slicers that are on the page. I want to also have the count include the measures that are filtering the page. I get the correct number of rows in my table and the correct IDs based on the slicer selections on this page and the slicers for the measures on another page, but I can't get the correct count.
Thank you.
Hi sheap069 ,
I'm not sure if I understand you correctly. Are you want to count a value based on the slicer on current page along with measures on an other page?
If so you could try to create a measure like below.
Measure 2 = CALCULATE(COUNT('Table'[id]),FILTER('Table',SELECTEDVALUE('Table'[year])='Table'[year]&&[Measure]=1))Here's my sample data and result.
Measure = IF(SELECTEDVALUE('Table'[value])>30,1,0)Best Regards,
Jay
2 Replies
what is the definition of what you are trying to count exactly. What is contained in the table that you want? Can you provide some examples of where the count is not working for you. Visuals are useful, data even better.
Hi sheap069 ,
I'm not sure if I understand you correctly. Are you want to count a value based on the slicer on current page along with measures on an other page?
If so you could try to create a measure like below.
Measure 2 = CALCULATE(COUNT('Table'[id]),FILTER('Table',SELECTEDVALUE('Table'[year])='Table'[year]&&[Measure]=1))Here's my sample data and result.
Measure = IF(SELECTEDVALUE('Table'[value])>30,1,0)Best Regards,
Jay
