Measure Efficiency -- Get distinct values, average per single date, then sum the averages

Hey everyone,

I'm trying to find a way to refactor this measure to make it more efficient, since it's currently pretty slow. I've been spinning my wheels, so any help is greatly appreciated.

We need to get distinct values per Employee & Date because the TLG table also has a more granular line level, and Workday Days is just per Employee & Date Worked.

The general idea here is that two different employees can have a different workday per date, because one might be in a country that has different holidays or weekends from the other. So in order to get the real total workdays for "Hours per Day" denominators etc, I need to find average workdays for each date.

EVALUATE

VAR DistinctEmpDays = 

		SUMMARIZE(
        		TLG
                , TLG[Date Worked], TLG[Employee ID], TLG[Workday Days]
        )
        
VAR AvgDays = /* Average workdays per single day */

        GROUPBY(
        		DistinctEmpDays
                , [Date Worked]
                , "AvgWorkdays"
                , AVERAGEX( CURRENTGROUP(), [Workday Days] ) 
        )
        
VAR Total = /* Sum daily avg for total workdays */

		SUMX( AvgDays, [AvgWorkdays] )
                
RETURN  
		ROW("Test", Total)