Forum Discussion
Summing column values based on slicer selection
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
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 VHi 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