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. 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

ermak A little hard to follow. Maybe you want Lookup Min/Max? https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434

 

Otherwise, not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.