Forum Discussion

charleshale's avatar
charleshale
Continued Contributor
5 years ago
Solved

Addcolumns with text

What do we think is the best way with extremely large tables to append one column to another with dax assuming both  are values?   I am using crossjoin and it's killing me with processing load.   S...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    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.⚡

parry2k's avatar
parry2k
Super User
5 years ago

charleshale what is your ultimate goal, do you want to visualize the user which are common between two tables or what?

  • charleshale's avatar
    charleshale
    Continued Contributor
    5 years ago

    The ultimate goal is an Intersect between 2 table columns that have an inactive relationship.

     

    Specifically, I want to lok at the overlap  between emailsubs and registereduserIDs but maintain an indirect relationship between the two.   So I could simply take my registereduserIDs table, do a lookupvalue and add email address, and then intersect....and that would work but I am trying to see if I can avoid adding the tables, which is probably dumb since they are 10m row tables and it's much more efficient to add columns