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))
        )
    )
)
AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
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))
        )
    )
)
GON76's avatar
GON76
Icon for Helper III rankHelper III
1 year ago

Getting closer!  Now instead of showing Blank the card is showing "1".  Out of curiosity, why did you decide to use "V_SECTIONCUSTOMFIELDS"?  This table houses the custom fields that we created in our learning management system.  They way I'm displaying my visual is to count the STUDENTINDEXs enrolled in each course or in LMS-speak, Section.  Thanks!