How to sumarize values from selected columns

[Tomek1982]

I have a following slicer and a table:

How to calculate "temp total" based on a slicer selection?

Expected result would should follow standard slicer functionality, eg.:

- when "a" selected then "temp total" = "value a"

- when "a" and "b" selected then "total temp" = "value a" + "value b"

- when nothing selected then "total temp" = "value a" + "value b" + "value c" + "value d" + "value e" + "value f"

[v-yalanwu-msft]

Hi, @Tomek1982 ;

You could unpivot the columns in power query.

1.tranfroms -> unpivot columns 

2. add matrix visual.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tomek1982]

Hi,

I already did pivot. The story behind is that I had some missing data. I did pivot to fill the gaps. I do not think I can unpivot this table, or can I?

Example PBIX 

I would like to chooose variables in the lower graph by slicer

[Jayee]

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Tomek1982]

Hi,

I already did pivot. The story behind is that I had some missing data. I did pivot to fill the gaps. I do not think I can unpivot this table, or can I?

Example PBIX 

I would like to chooose variables in the lower graph by slicer