Simple (Date Sliced) Time Distribution w/ Inactive Relation

[Anonymous]

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!

[Anonymous · Accepted solution]

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]

..

[Anonymous]

Sounds like a reply from ChatGPT and looks rather useless to me