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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
norworrrr
New Member

If id is blank i want to return 0

From this DAX how can i check id blank
 
First lead id =
VAR firstassigndate =
CALCULATE (
        MIN ( 'lead'[created_at] ),
        ALLEXCEPT('lead', 'lead'[id])
    )
RETURN
    CALCULATE (
        SELECTEDVALUE ('lead'[Lead ID]),
        FILTER (
            ALLEXCEPT( 'lead', 'lead'[id]),
            'lead'[created_at] = firstassigndate
        )
    )
1 REPLY 1
Tahreem24
Super User
Super User

@norworrrr , simply add +0 at the end .

 

First lead id =
VAR firstassigndate =
CALCULATE (
        MIN ( 'lead'[created_at] ),
        ALLEXCEPT('lead''lead'[id])
    )
RETURN
    CALCULATE (
        SELECTEDVALUE ('lead'[Lead ID]),
        FILTER (
            ALLEXCEPT'lead''lead'[id]),
            'lead'[created_at] = firstassigndate
        )
    ) +0
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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