Forum Discussion

GON76's avatar
GON76
Icon for Helper III rankHelper III
1 year ago
Solved

Counting Blank Fields on a Column that's Counting Values

A little background:   I'm trying to count blank fields for a column which is displaying a count of values, the valued that I'm seeing on the card is (blank).   I'm working in a learning environm...
Need Help
  • AmiraBedh's avatar
    AmiraBedh
    1 year ago

    You are right ! I forgot the FILTER it should be like below :

    No Enrollments :=
CALCULATE(
    COUNTROWS(V_SECTIONCUSTOMFIELDS),
    FILTER(
        V_SECTIONCUSTOMFIELDS,
        ISBLANK(
            CALCULATE(COUNTROWS(V_ENROLLMENTS))
        )
    )
)
muhammad_786_1's avatar
muhammad_786_1
Icon for Solution Supplier rankSolution Supplier
1 year ago

Hi GON76

 

Please see if this is what you want.

You can try this measure if you have separate `COURSES` and `V_STUDENTS` tables with a relationship on CourseID:

 

BlankCount =
COUNTROWS(
FILTER(
COURSES,
ISBLANK(CALCULATE(COUNTROWS(V_STUDENTS)))
)
)


It will count how many courses have no enrollments.

 

Best Regards,
Muhammad Yousaf

 

If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

LinkedIn