Forum Discussion
Data changes after click row
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.
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.
Power ParticipantAre 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.
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)* -1Which 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?nvm it was being summed. Thanks for the help.
- 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?
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