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 looking at your pbix file, what is your goal? What you want the expected result? For a second forget about the solution to how to get there.

  • charleshale's avatar
    charleshale
    Continued Contributor
    5 years ago

    On the PBIX file the only intersect between email and registered user IDs would be the first row if these were the 3 tables ([email protected]).   Basically, another way to ask the question is "what's the best way to do a 3 way intersect!"?    (PS assuming there are inactive relationships involved)