Forum Discussion

nroeder's avatar
nroeder
Frequent Visitor
4 years ago
Solved

Data changes after click row

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 ...
Need Help
  • Jeanxyz's avatar
    Jeanxyz
    4 years ago

    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's avatar
nroeder
Frequent Visitor
4 years ago

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

 

Basic Table Layout

PropertyTable

PropertyIdCustomer Name
1Joe smith
2David Small

 

ActivityTable

ActivityId

PropertyIdDetailsDate
11talked to customer

08/31/2022

 

22Met Inspector

9/1/2022

31Collected 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's avatar
Jeanxyz
Power Participant
4 years ago

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