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.