Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |