Return Result as 0 in lieu of blank

[AMBP73]

Hi,

Power BI novice here.

I am wondering if someone could please assist. I have the following measure applied to a card visual to return a count of documents with dates (indicating overdue) before today's date, however as there are some that have no date applied, when filtering it return a a 'Blank' result. In lieu of this I would like it to display '0', but nothing I am trying is working. Can an additional condition be added to achieve this?

E&T Total Overdue = COUNTROWS(FILTER('E&T Document',NOT(ISBLANK('E&T Document'[Cancellation Date]))&&'E&T Document'[Cancellation Date]<TODAY()))

Thanks in advance

[eliasayyy · Accepted solution]

hello you have 2 solutions
1-  Craete a new Measure  

No Blanks = 
IF(ISBLANK([E&T Total Overdue]),0,[E&T Total Overdue])

2- Use the new card visual

and change the show blank as to 0

[AMBP73]

Thankyou, much appreciated!