Forum Discussion
GON76
Helper III
Helper IIICounting 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...
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)) ) ) )
GON76Helper III
Helper IIIThat gave me an error:
AmiraBedh
Super User
Super UserYou 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
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!
- GON76
I ended up using this and it worked!
= CALCULATE( COUNTROWS(V_SECTIONS), FILTER( V_SECTIONS, ISBLANK( CALCULATE(COUNTROWS(V_ENROLLMENTS)) ) ) )