Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

FIRSTNONBLANK not returning every value

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?



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




Super User
Super User

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.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors