Forum Discussion
Working with 2 time dimensions
You can use the USERELATIONSHIP function when you need to use the inactive relationship in your measures.
Here's a good explanation: https://www.sqlbi.com/articles/userelationship-in-calculated-columns/
Those measures look pretty good to me. (I assume that '311_details'[DDS] is just the request ID field?)
I would carefully check the relationships that you have set up. If possible, while troubleshooting, remove/deactivate all relationships except the active relationship between Date and Close Date, and the inactive one between Date and Open Date.
I looked back at that page today and I just see perferct numbers
I swear I did not even do a refresh or reload or whatever of that nature (at least that I am aware of).
I'm actually glad I have a screenshot of the weird Created request count to prove I'm not crazy and that I did get those numbers yesterday.
I'm just glad it works today and will put that one on IT witchcraft.
Thanks MalS for the follow-up anyway
It is happening again !
I have been banging my head on the wall all day!
When only the Created request is present the date get associated with the creation date
But as soon I put on the grid a measure, which calculation goes through the close date, then the Created request measure "forgets" it is supposed to go through the creation date and instead sees the date as the close date, getting the data for all the creation dates associated with the current close date, thus bumping up the numbers significantly.
This is driving me nuts. Especially considering that it miraculously worked at some point