Measure divided by # days worked (10.13.21)

Hi jonnyA ,

I have built a data sample:

According to your description, it seems that you want to change the total average rather than the each cell as shown below:

If so,please try:

Average=
VAR _totalAvg =
    DIVIDE (
        SUMX ( 'vw_Test Dataset_Discharge_Dataset', [# of Patients Per Shift] ),
        DISTINCTCOUNT ( 'vw_Test Dataset_Discharge_Dataset'[Shift Name] )
    )
RETURN
    IF (
        ISINSCOPE ( 'vw_Test Dataset_Discharge_Dataset'[Shift Name] ),
        [Your original Measure],
        _totalAvg
    )

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 Thank you so much for your formula, high five!!!

I had to change Shift Name to DOS, so when I did that your formula worked!!!

Thank you so much for your time and effort and for providing the data sample, that helps a lot!!!

Trying to mark yours as solution, but do not have the option?

Anonymous