Not sure about the visual representation and data related details but i would suggest you can create a inactive relationship with the discharge date and in all the measures use the userelationship  DAX Function.

If this doesnt helps can you please share a sample pbix with sensitive data removed  so that we can check ?

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/

Hi,

the one you suggest is an option.

Otherwise you have to create another inactive relationship between your date table and the fact table  (Date table on Discharge date) and then use USERELATIONSHIP to activate it when you need.

There are advantages and disadvantages in both solutions.

You can find tutorial like this

UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI by Radacad

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !