Forum Discussion
filling empty cells with 0
Hello, I would like to fill empty cell with zero, how can I do that? As you see on the picture, I have some empty cells... This is my measure Total Pending = CALCULATE( COUNTROWS('CecCa...
Hi Anonymous ,
Try below code :
Total Pending =
COALESCE(
CALCULATE(
COUNTROWS('CecCaseDetail H'),
'CecCaseDetail H'[Case] IN {"New", "Enhanced", "Stand"}
),
0
)
Thanks,
Ankita
It works Thank you.