Data changes after click row

[nroeder]

I'm hoping someone much smarter than I am can help. I have 2 tables shown on a report. Clicking on the row of 1 table makes that data in the second table disappear despite the data being tied to the row. Please help.

Top image row not clicked, bottom image row clicked.

[Jeanxyz]

By default, there is interaction between visuals on the same page, meaning when you click one row in one table, the filtering context is passed to other visuals on the page. 

Here is video about interaction and how to de-activate it. 

https://www.youtube.com/watch?v=KQsRHWTF4Bs

[nroeder]

Yeah I understand that and that's what I want to happen. But in this instance that record is tied to the record below and should still show when clicked on. However it does not. Also not that the count of property goes to blank when selected. That should not be possible. 

[Jeanxyz · Accepted solution]

Are the data from two visuals coming from the same fact_sheet? If not, better check the relationship diagram. I'm making a bold guess: could you use one dim_date table and link it to [ActiveDateTime] and [CreatedDate]? If that's the case, the interaction will cause 2nd table to disappear. 

[nroeder]

Ok I think that solved that problem but now i've ran into another problem.

Basic Table Layout

PropertyTable

PropertyId	Customer Name
1	Joe smith
2	David Small

ActivityTable

ActivityId	PropertyId	Details	Date
1	1	talked to customer	08/31/2022
2	2	Met Inspector	9/1/2022
3	1	Collected Check	9/1/2022

So in my report I have two tables show in the pictures above.

In the top table I have a new column with the following formula

Last Activity = DATEDIFF(TODAY(), DATEVALUE(max(Activity[ActivityDateTime],Activity[PropertyId])), DAY)* -1

Which returns how many days have passed since contact with the customer has been made.

The issue is in the second table below, only the last activity for that customer will now show.

Any ideas how to fix this?

[Jeanxyz]

What's the key between PropertyTable and ActivityTable, propertyID? Meaning propertyID is your customer ID? You need to create a visual to show date difference per customer per activity?

@nroeder 

Please see pbix file attached. If that's not what you need, please upload a sample file to help us help you. 

https://www.dropbox.com/s/1j1ckz0o21smorf/date%20diff.pbix?dl=0

[nroeder]

nvm it was being summed. Thanks for the help.