Summing column values based on slicer selection

[Anonymous]

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. 

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

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

[Nathaniel_C]

Hi @Anonymous ,

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

[Washivale · Accepted solution]

Hi @Anonymous ,

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

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

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

[Anonymous]

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?

[Washivale]

Hi @Anonymous ,

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

[Anonymous]

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

[Washivale]

HI @Anonymous ,

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

Regards,

Washivale