How can I make it take only the values that are not null?

[Syndicate_Admin]

I am measuring productivity and I have the units manufactured for each worker for each date, for which I create a graph that shows me the average productivity, and a letter that shows me the average of all workers.

 

The issue is that it is not the real value for March since it takes into account dates in which it was not worked (examples Sunday and some Saturdays)

average average productivity per day = [average productivity day]/DISTINCTCOUNT('list of employees'[id])

average productivity day = SUM(Sheet1[Units])/(DISTINCTCOUNT(Sheet1[Date].[Day]))

It works well for me if in the filter I choose day by day, knowing the days that were worked but I need to select several months and calculate myself based on all the days that is not null / white

[v-kkf-msft · Accepted solution]

Hi @Syndicate_Admin ,

Please try the following formula:

average productivity day = 
SUM ( Sheet1[Units] ) / CALCULATE ( DISTINCTCOUNT ( Sheet1[Date] ), Sheet1[Units] <> BLANK () ) 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

I tried to create a new measurement with DISTINCTCOUNTNONULL(date) but I need you to use the date filter of the photo.

Is there a way to use a "slicer" as a filter for a measurement?