Sum KPI values when removing attributes from a table visual using slicer selection

[atrigo]

Hi all,

I have the following table created using a slicer selection that allows me to add or remove columns. 

The approach used is described here:

https://community.powerbi.com/t5/Desktop/Dynamically-add-or-remove-columns-from-table-visual-using-s...

However, The Sales values are not summed up when I remove Country and leave only Region. See the result below:

As report user, I would expect to have only 1 row for each region and the total sales for that region. Is that possible?

Thank you very much in advance for your support!!

Best regards

[atrigo]

Thanks a lot @amitchandak and @v-yetao1-msft . I will keep investigating for an alternative solution to attend the requirement to add or remove columns dynamically, with an automatic aggregation of values.

Best regards

[v-yetao1-msft]

Hi @atrigo 

Since your index is a unique value, there is no way to achieve only one row for each area you said.

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@atrigo , You still have the index column, that is unique for each row.