I am stuck with a specific measure and wondering if someone here have any guidance.

I am putting a measure together that identifies two specific dates, located in different tables in the data model, and calculate the number of days between the two dates; i am referring to this measure as [POP Days]. Not only do I want to determine the total number of days between the two dates, i want to return the final median aggregate for a context of rows. As you can see below, the measure is working just fine for each individual row however the final aggregate is showing the number of days for the first date for each column. I tried to establish row context by using variables and a virtual table but am still not successful. Any guidance would be greatly appreciated.

Thanks Sam for the reference and the support. I have watched the video and your logic makes sense. Once I get back to my computer, Iâ€™ll get back on the report to incorporate this method in the Dax and let you know what I come up with.

Hi @JoeRobert, a response on this post has been tagged as â€śSolutionâ€ť. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!"

You know how when you are staring at a measure for a long time and for the life of you you cannot figure out how to write it correctly. Then after taking a break from looking at you, you are able to solve the formula after a short time period? Well that is what just happened to me here.

I simplified the measure by removing the variables and branching the individual measures in the formula and I am getting the correct median value as the final aggregate. I cannot explain why variables do not give you the same response as branching measures, maybe one day I will figure it out.

See below screenshot the final measure where I am getting the correct median value for the final aggregate.

You know how when you are staring at a measure for a long time and for the life of you you cannot figure out how to write it correctly. Then after taking a break from looking at you, you are able to solve the formula after a short time period?

Yup, happens to me all the time.

I suspect this may help you solve the mystery of why the measure worked when the variables didnâ€™t: