'How do I add if isBlank keeps failing

Current I have this and works well

CALCULATE(if(ISBLANK(PDR[Count test]),0,COUNTROWS(Pdr)))

How do I add a '0' or 'NA' if the field has no data. Thanks



Solution 1:[1]

Try:

COALESCE( COUNTROWS(Pdr), 0 )

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 intruderr