Forum Discussion

TBenders's avatar
TBenders
Icon for Helper II rankHelper II
10 years ago

Showing 0 from a measure in a table visualisation

Hi,   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 wa...
Need Help
TBenders's avatar
TBenders
Icon for Helper II rankHelper II
10 years ago

Thanks a lot for your effort Baskar, but still no luck!

Anonymous's avatar
Anonymous
Not applicable
10 years ago

How about

 

Measure = VAR ivct = CALCULATE(COUNTROWS(FILTER('Applications';'Applications'[Status] = "Interviews"))) RETURN IF(ivct = 0, 0, ivct)