How to sumarize values from selected columns

Question

I have a following slicer and a table:&nbsp;&nbsp;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" =&nbsp;"value a" + "value b" + "value c" + "value d" + "value e" + "value f"

jayee · Answer

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

v-yalanwu-msft · Answer

Hi,&nbsp;Tomek1982&nbsp;;
You could unpivot the columns in power query.
1.tranfroms -&gt; unpivot columns&nbsp;

2. add matrix visual.

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

tomek1982 · Answer

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?&nbsp;&nbsp;Example PBIX&nbsp;&nbsp;I would like to chooose variables in the lower graph by slicer

tomek1982 · Answer

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?&nbsp;&nbsp;&nbsp;Example PBIX&nbsp;&nbsp;I would like to chooose variables in the lower graph by slicer