Forum Discussion
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. ...
Please try this measure instead.
NewMeasure = Sumx(Values(TLG[Date]), calculate(average(TLG[Workday Days])))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Thank you, but this won't work. It doesn't change the granularity to Employee & Date Worked, so it's aggregating millions of duplicates.