Forum Discussion

ermak's avatar
ermak
Frequent Visitor
6 years ago
Solved

SUM value from only the first occurrence

I have two tables ('UserID' and 'User_Balance'). In one - the source of traffic and user ids, in others, user ids and their balances. I create a connection and display into a table just the sums of u...
  • stevedep's avatar
    stevedep
    6 years ago

    Hi ermak ,

     

    See below:

     

     

     

    __New = 
SUMX(SUMMARIZE(ALL_HITS,ALL_HITS[user_id], "b",
IF(
 CALCULATE(FIRSTNONBLANK(ALL_HITS[date],MIN(ALL_HITS[hits_referer])), ALLEXCEPT(ALL_HITS, ALL_HITS[user_id])) = MIN(ALL_HITS[date]) , MIN('Users Balance'[Balance USD]), BLANK())
),[b])

     

     

     

    Link to file. 

     

    Please mark as solution if so. Thumbs up for the effort are appreciated.

     

    Kind regards, 

     

    Steve. 

stevedep's avatar
stevedep
Icon for Memorable Member rankMemorable Member
6 years ago

Hi ermak ,

 

See below:

 

 

 

__New = 
SUMX(SUMMARIZE(ALL_HITS,ALL_HITS[user_id], "b",
IF(
 CALCULATE(FIRSTNONBLANK(ALL_HITS[date],MIN(ALL_HITS[hits_referer])), ALLEXCEPT(ALL_HITS, ALL_HITS[user_id])) = MIN(ALL_HITS[date]) , MIN('Users Balance'[Balance USD]), BLANK())
),[b])

 

 

 

Link to file. 

 

Please mark as solution if so. Thumbs up for the effort are appreciated.

 

Kind regards, 

 

Steve. 

ermak's avatar
ermak
Frequent Visitor
6 years ago

stevedep Thank you very much! On test data, your solution works for me. But when I try to apply it to a working project it doesn't work. And I can't figure out what's the matter.

 

Link