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)) ) ) )
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))
)
)
)
GON76Helper III
Helper IIII ended up using this and it worked!
= CALCULATE( COUNTROWS(V_SECTIONS), FILTER( V_SECTIONS, ISBLANK( CALCULATE(COUNTROWS(V_ENROLLMENTS)) ) ) )