Forum Discussion
slhangen
Helper II
Helper IINeed count with multiple filters
I have created and Append table and need to get some calculations from it. Table is called Append1 and looks like following: TITLE STUDENT LAST NAME STUDENT FIRST NAME DESIGNATION COURSE TE...
Take a look at the following slhangen - just one measure I think is all you need:
Course Failures = COUNTX( FILTER( 'Table', 'Table'[SEMESTER GRADE] = "F" ), 'Table'[SEMESTER GRADE] )Simply add the fields I have added to a Table visual, then add the Course Failures measure I created. It will calculate the correct numbers per semester.
If that is not what you need, could you be more specific in the output you require and the logic to get there?
