Forum Discussion
Anonymous
2 years agoNot applicable
Simple (Date Sliced) Time Distribution w/ Inactive Relation
Hello, supposedly a very simple problem. "Table1": ... "TimeTable" (full data is 08:00:00 - 16:30:00): ... "DateTable" (2020-07-01 - Today): .... Relationships: ...
- Anonymous2 years ago
I found the solution, the USERELATIONSHIP function has to be wrapped in another CALCULATE like this Measure2 = CALCULATE(CALCULATE(...)), USERELATIONSHIP(..))). Weird because it also clearly had an effect when using it inside a single CALCULATE with the other functions. My lack of DAX knowledge prevents me to properly understand whats happening but fortunately it works now.
123abc
2 years agoCommunity Champion
..
- Anonymous2 years agoNot applicable
Sounds like a reply from ChatGPT and looks rather useless to me