Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 w...
  • Nathaniel_C's avatar
    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

  • Washivale's avatar
    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