SUM multiple columns based on user selection

[Anonymous]

Your help please and I am open to any ideas and solutions on how to accomplish this.

I have a data table with 4 columns; columns A,B & C are whole numbers and Type is text (see example below).

The client wants the ability to select any combination of columns A, B and/or C with the expected result being the sum of the selected columns.

EXAMPLE

Data Table
A	B	C	Type
5	2	1	Bird
3	6	2	Cat

measures: a=

a = calculate(  sum( A ) )

b = calculate( sum( B ) )

c = calculate( sum( C ) )

Slicer #1	Slicer #2
A	Bird
B	Cat
C

Scenario #1:	Scenario #2:	Scenario #3:
Selected Slicer #1:  A, B, C	Selected Slicer #1:  A, C	Selected Slicer #1:  A
Selected Slicer #2: Bird	Selected Slicer #2: Bird	Selected Slicer #2: Cat
Expexted Total : 5+2+1 = 8	Expexted Total : 5+1 = 6	Expexted Total : 3

Results Table
scenario	total	Type
#1	8	Bird
#2	6	Bird
#3	3	Cat

Thank you advance for your input, ideas and help

[ryan_mayu · Accepted solution]

@Anonymous 

you can select the type column and unpivot other columns in PQ

pls see the attachment below