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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Trying to show a message on a card if there are no new records in last 7 days

Hi all.  I'm new to Power BI and DAX.  I'm working on attempting to use a measure using DAX that displays  the message "No new registrations in the last 7 days" if there are no new registrations in the last 7 days, but not having much success.  The DAX Code I am using is:

 

NoRegistrations = if(ISBLANK(DimCompany[registration_effective_date]>=Today()-7), "No new registrations in the last 7 days","")

 

The error message I am getting is "A single value for column'registration in table 'DimCompany' cannot be determined.  This can hapened when a measure formula refers to a column that contains mny values without specifying an aggregation such as min, max, count, or sum to  get a single result.
 
Thanks in advance for assistance.
1 REPLY 1
Anonymous
Not applicable

I was able to fix the issus using 

New Registrations = IF(ISBLANK(Calculate(Count(DimCompany[Registration_Id]), Filter(DimCompany, DimCompany[registration_effective_date]>=Today()-7))), "No new registrations in the last 7 days","")

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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