Forum Discussion
Count Rows of a Visual Table
- 1 year ago
It looks like the number of rows is determined by unique combinations of EMAIL ADDRESS, ARTIFACT SUBMISSION, and COURSE.
Assuming these are all columns of a single table named Table1, I'd expect something like this to work:
COUNTROWS ( SUMMARIZECOLUMNS ( Table1[EMAIL ADDRESS], Table1[ARTIFACT SUBMISSION], Table1[COURSE] ) ) - 1 year ago
Hi barragan82,
Thank you for reaching out to the Microsoft fabric community forum. Thank you AlexisOlson for your input on this issue.
After reviewing the details you provided, I was able to reproduce the scenario, I have used it as sample data on my end and implemented it.Dax Measure:
Row Visual Count = IF( ISINSCOPE('Instructors'[EMAIL ADDRESS]) && ISINSCOPE('Instructors'[COURSE]), 1, COUNTROWS( SUMMARIZE( 'Instructors', 'Instructors'[EMAIL ADDRESS], 'Instructors'[COURSE] ) ) )
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
If you are asking what I think you are asking, there might be a simpler solution for you.
The short version is create a measure like this and add it to your table:
RowsDisplayed_TotalOnly = IF(ISINSCOPE('DataTableName'[PrimaryKeyFieldName]), " ", COUNTROWS(ALLSELECTED('DataTableName')))
For more details on usage and why it works, see my recent comment on Solved: How to display the count of the rows in a table vi... - Microsoft Fabric Community.
- barragan829 months agoHelper II
Thank you, BonnieW! I'll keep this in mind the next time I need this function.