Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
AA622
Helper II
Helper II

COUNTA if blank

Hello

 

I am using COUNTA to count whenever there isnt a date in a row and then i put it in a card to showcase count.

DOScountbypurchase = COUNTA(Table[Dateofpurchase])
 
When I select a value where there is no date of purchase it shows "blank" in the card.(see below)
AA622_0-1703018216996.png

 

How do I showcase a custom message whether it be "0" or "No Dates" instead of saying "(Blank)". 

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Drag this measure to a card visual

Measure = coalesce([DOSCountbypurchase],0)

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
ryan_mayu
Super User
Super User

@AA622 

you can try this

 

DOScountbypurchase = COUNTA(Table[Dateofpurchase]) +0

 

or 

 

DOScountbypurchase =if(isblank( COUNTA(Table[Dateofpurchase])),"No Dates")





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors