cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Resolver I

## Measure to sum everything with same id

Hello Comunity,

Sample data:

 ProductId Trip Value 1 1 9 2 1 9 3 1 9 4 1 9 5 2 9 1 2 9 5 2 9 6 2 9 7 3 9 2 3 9 3 3 9

On a report page there is a slicer with "ProductId", if the user chooses ProductId 2 then I need to identify Trips that has this ProductId and sum the entire Trip value.

For ProductId 2 this would mean Trip number 1 and 3 meaning the sum total would be 63 (Trip 1 total + Trip 2 total).

Can this be done with DAX?

4 REPLIES 4
Super User

@BIanon I have something similar resolved here How to override slicer selection to return all records | PeryTUS - Power BI How To - YouTube

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Super User

Yes DAX can handle this.  I would handle like this.  Create 2 Calculated Columns:

``````Trip_Sum = CALCULATE( SUM(Products1[Value] ),
ALLEXCEPT( Products1, Products1[Trip] ))

ProductID_Sum = CALCULATE( SUM(Products1[Trip_Sum]),
ALLEXCEPT( Products1, Products1[ProductId] ))``````

 ProductId Trip Value Trip_Sum ProductID_Sum 1 1 9 36 72 2 1 9 36 63 3 1 9 36 63 4 1 9 36 36 5 2 9 36 72 1 2 9 36 72 5 2 9 36 72 6 2 9 36 36 7 3 9 27 27 2 3 9 27 63 3 3 9 27 63

With more time, you can probably do this in one step, but this gives more visibility to your calculations.

Hope this helps.

Regards,

Resolver I

Thank you for the reply.

Would I be able to solve this with a measure instead of a calculated col ?

Super User

Yes, I'm sure this can be done with a Measure.  However, variables and variable tables are not my strong suit.  Going to tag a couple of folks who I think may be able to solve this with a Measure.

@parry2k , @Jihwan_Kim - hope you might lend an assist here.

Thanks and Regards,

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors