Forum Discussion

chucknorris's avatar
chucknorris
New Member
4 years ago
Solved

Total sum by unique user

Hello everybody, I want to calculate total quantity value at a certain warehouse id (that can be selected via power bi GUI). The value should be shown at first occurence of a unique customerNumbe...
DAX Measures
Group By
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi chucknorris ,

     

    If you want to group summation by userid, you can refer to a formula like this, which applies to group summation, and modify it accordingly according to your actual situation.

    Measure = CALCULATE(SUM('Table (2)'[Value]),FILTER(ALL('Table (2)'),'Table (2)'[Attribute]=SELECTEDVALUE('Table (2)'[Attribute])))

    You can see that it is grouped by attribute. In your case, just replace it with "user id ".

     

    Best regards,

    Community Support Team Selina zhu

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi chucknorris ,

 

If you want to group summation by userid, you can refer to a formula like this, which applies to group summation, and modify it accordingly according to your actual situation.

Measure = CALCULATE(SUM('Table (2)'[Value]),FILTER(ALL('Table (2)'),'Table (2)'[Attribute]=SELECTEDVALUE('Table (2)'[Attribute])))

You can see that it is grouped by attribute. In your case, just replace it with "user id ".

 

Best regards,

Community Support Team Selina zhu

 

 

chucknorris's avatar
chucknorris
New Member
4 years ago

Hi Selina,

thank you for your answer. 
This solution with measure 

Measure2 = CALCULATE(SUM(testdata_powerbi[correctlySortedOrderQuantity]),FILTER(ALL(testdata_powerbi),testdata_powerbi[userId]=SELECTEDVALUE(testdata_powerbi[userId])))

works! 🙂
Kind regards, 
Chuck Norris