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 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
This is giving me sum of all the plant groups i.e. 78k
- Washivale6 years agoResolver V
HI Anonymous ,
All three Measures Resulting into 78k? Try selecting/deselectiong plant groups to check end output for all three measures.
Regards,
Washivale