Forum Discussion
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.
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.
NathanielHi 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
7 Replies
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
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.
NathanielHI Anonymous ,
All three Measures Resulting into 78k? Try selecting/deselectiong plant groups to check end output for all three measures.
Regards,
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
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