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.
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]
)
)
- barragan821 year agoHelper II
That did exactly what I needed. Thank you.