Forum Discussion
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:
I have a Date Slicer (DateTable[Date]) on my report page and have a visualization for my [LastUpdateTime] (with x-axis [Time_only] & y-axis Measure1 = CALCULATE(COUNTROWS('Table1'), GROUPBY('Table1','Table1'[LastUpdateTime])) )
So far so good, result is as expected (sum of the row count per 1min time window for the date range defined by the Date Slicer).
NOW, I would like to have the same visualization on my report page but for [IssueTime].
For this I've tried using the following measure:
Measure2 = CALCULATE(COUNTROWS('Table1'), USERELATIONSHIP(DayTable[Time_only],'Table1'[IssueTime]), GROUPBY('Table1','Table1'[IssueTime]))
BUT result is not as expected (not showing any counts or only very few when extending the date range via Date Slicer significantly).
What am i missing and how can i solve this problem?
Thanks!
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.
3 Replies
..
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.
