I'm using the following measure to calculate howmany applicants had an interview. This works and I'm using this measure in a table-visualisation. 0's are not showing in my table which I do want to see instead of a blank space.
Interviews = CALCULATE(COUNTROWS(FILTER('Applications';'Applications'[Status] = "Interviews")))
How can I make sure that rows (vacancies) which had no interviews take place show a 0 instead of nothing? I have tried some things I found on the forum but nothing worked out for me (or I mis-used them), such as adding +0 and using if isblank. It's also not possible to 'show items with no data' on a measure...
Hope someone can help me out!
@TBenders So if ISBLANK is not helping
Try creating a Column = 0
Look at my response here...
Thank you for your response!
A lot of the other columns in the table already have numbers in them. I have also added the 1-column but this has no effect on the empty spaces.
It could be that I mis-used the ISBLANK. Could you show me how my measure would look using ISBLANK?
@TBenders You don't really need the CALCULATE
This should work
Measure = IF ( ISBLANK ( COUNTROWS ( FILTER ( 'Applications'; 'Applications'[Status] = "Interviews" ) ) ); 0; COUNTROWS ( FILTER ( 'Applications'; 'Applications'[Status] = "Interviews" ) ) )
ISBLANK didn't work; it still just shows empty spaces. Also when I replace the 0 with 18 for example, it still doesnt show the 18 values. Could this be because its not actually blanks that's being returned but 0's, and these 0's are not showing up?