FIRSTNONBLANK not returning every value

[sstewarta]

Hello all,

I have the below DAX expression to return the use name from a table that has multiple values to a table with single values. I am joining them by the date but for some reason on 3/4th of the values gets pulled over. Note: there is only one username next to each distinct date on the multi table.  I have checked all the dates and there are true values to be pulled for the dates missing. below I also have an example of the results. Does anyone know why I would get spotty results when that data is there just like any of the other rows that found a value?

Expression: 

User Worked = CALCULATE(
FIRSTNONBLANK( SearchTable[Processed by Name], 1),
FILTER( ALL(SearchTable), SearchTable[Date] = 'Calendar'[Date]))

UserName	5/25/2022
	5/24/2022
UserName	5/23/2022
	5/20/2022

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523