Forum Discussion

Juliecal73's avatar
Juliecal73
Icon for Helper III rankHelper III
5 years ago

Measure Slow with Added Relationship

Hi, I feel like I'm missing something fundamental in context here but I just can't figure out what. I have the following schema with relationships going to a fact table USA Timelisting and a Calend...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

First thing I would try is to pull the 

MIN(TODAY(), varTaskEnd)

into a variable and use it in the FILTER.

 

Pat

Juliecal73's avatar
Juliecal73
Icon for Helper III rankHelper III
5 years ago

Thanks mahoneypat . Yes, neater, but as expected did not make any difference to the performance.