I try to filter records in slice from table Contacts based on values in table Activities with this expression,
In(
Contacts[UniqueID] ,
OrderBy( Select( Activities[Contacts], True ), [LastSelect] )
)
, but it will not let me do that. Please let me know what I am doing wrong?
Solved! Go to Solution.
So first recommendation is just make a MAX_Activities slice with a formula similar to this
[CurrentTimeStamp]
=
MAX(
SELECT(
CurrentInvoice[CurrentTimeStamp],
[UserEmail]=USEREMAIL()
)
)
I donโt know how youโre Activities table is set up exactly but basically this slice is to filter down to the row you want just to make it easier to user in many places. From there you would just do IN([UniqueID],ANY(SELECT(MAX_ACTIVITIES[CONTACTS],true))
Slice filters are performed row by row so you donโt need Contacts[UniqueID]. I assume [Contacts] is a list column correct?
(what the heck happened to my text I was just trying to format the code and this happened)
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |