Show Items with No Data: Show Different Value than Blank

[Anonymous]

I have two datasets related (one-to-many) by an email column:

Employee Data: https://cabarruscountync-my.sharepoint.com/:x:/g/personal/lrpatterson_cabarruscounty_us/Eakp5E1JQb1J...

Submission Data: https://cabarruscountync-my.sharepoint.com/:x:/g/personal/lrpatterson_cabarruscounty_us/EVEpFsYsP2RE...

Example Dashboard: https://cabarruscountync-my.sharepoint.com/:u:/g/personal/lrpatterson_cabarruscounty_us/Ef-1PeSOlnVG...

Some of the records in the submission dataset are not in the employee dataset.  I have used "Show items with no data" to show submissions not in the employee dataset.  I need to hardcode a department name for each of these records not in the employee dataset.  How can this be done?

I have tried to make another "department" dax column like this:

dept = if(ISBLANK(EmployeeData[employee_depart]), "NEW VALUE", EmployeeData[employee_depart])

This obvisously doesn't work as "no data" items are not evaluated. 

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

You can create a measure as below and check whether that is what you want:

nDept = 
VAR _dept =
    CALCULATE (
        MAX ( 'EmployeeData'[employee_depart] ),
        FILTER (
            'EmployeeData',
            'EmployeeData'[employee_email] = MAX ( 'Submissions'[SubmitterEmail] )
        )
    )
RETURN
    IF ( ISBLANK ( _dept ), BLANK (), MAX ( EmployeeData[employee_depart] ) )​

In addition, you can review the following documentation to get the details of option "Show items with no data works".

How Show items with no data works

Best Regards