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