Forum Discussion
Addcolumns with text
charleshale here how dax will change:
Filter Intersect = VAR __countEmails = CALCULATE ( COUNTROWS ( EmailSubs ), USERELATIONSHIP ( EmailSubs[Email], Lookup[Email] ) //in case this EmailSubs table has inactive relatiobship ) VAR __countUsers = CALCULATE ( COUNTROWS ( 'Registered USers' ), USERELATIONSHIP ( 'Registered USers'[Registered User], Lookup[RegsteredUser#] ) //in case Registered USers table has inactive relatiobship ) RETURN IF ( __countEmails == BLANK() || __countUsers == BLANK() || MAX ( Lookup[Email] ) == BLANK(), BLANK() , 1 )Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
charleshale values function returns a table of unique values, in this on values of column2 and that's why you are getting this error. What you are trying to achieve?
It's really probably dumb. I have 3 huge tables. They are
1. Email subs by email address
2. Registered users by #
3. A user lookup table matching 1 and 2.
I am trying to figure out the intersection between 1. and 2. If I were practical, I would simply add a column to table 2 of email address using lookupvalue () and then user Intersect().
However, I am trying to see if I can do this virtually without killing the memory load by using crossjoin.
Maybe I should just be practical?
And here's a really dumbed down test file I have been using to see if I can measure intersect between one table and another where an indirect (or related) relationship is required
