cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Employee

## Summing column values based on slicer selection

I have a table with 2 fields, Plant group and capacity. When I am using plant code as a slicer, I want the capacity to sum up accordingly. See below, if I choose *787 & *245 as plant group, I would want the capacity to show up as 30000 in my visual.

2 ACCEPTED SOLUTIONS
Super User

Create a measure = SUM(table[Capacity]) and drop it on a Card. Select the [Plant Group ]as Slicer.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Proud to be a Super User!

Resolver V

Create measures as below to understand outcome behaviour on slicer selection

Measure1 = Sum(Table[Capacity])

Measure2 = Calculate(Measure1, ALL(Table[Plant Group]))

Measure3 = Calculate(Measure1, ALLSELECTED(Table[Plant Group]))

let me know if it helps,

Regards,

Washivale

7 REPLIES 7
Super User

It works for me. PBIX
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Proud to be a Super User!

Resolver V

Create measures as below to understand outcome behaviour on slicer selection

Measure1 = Sum(Table[Capacity])

Measure2 = Calculate(Measure1, ALL(Table[Plant Group]))

Measure3 = Calculate(Measure1, ALLSELECTED(Table[Plant Group]))

let me know if it helps,

Regards,

Washivale

Super User

Create a measure = SUM(table[Capacity]) and drop it on a Card. Select the [Plant Group ]as Slicer.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Proud to be a Super User!

Employee

I was pulling the Plant group from another table. It looks like a relationship issue. Once I changed it from single to "Both", it showed me correct result. Working fine now but I do want to understand how does this relationship work? Any idea?

Resolver V

Glad you were able to figure it out. for understanding how relationships work, below would be a good starting point.

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

Regards,

Washivale

Employee

This is giving me sum of all the plant groups i.e. 78k

Resolver V

All three Measures Resulting into 78k? Try selecting/deselectiong plant groups to check end output for all three measures.

Regards,

Washivale

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

#### Power BI Monthly Update - March 2024

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

Top Solution Authors
Top Kudoed Authors