Modify table comuns based on filters

[lucafirefox]

I have a table like the one below and I would like to modify a column based on a filter criteria I apply using a dropdown menu.

Filter: clientAAA

Country	Sales by all clients	Sales by clientAAA
Spain	30000	100
France	6400	3000
Italy	5000	50

My idea is to have a slicer where I can select a client or a bunch of them and modify the last column of my sales table showing the sales done by the selected client split by countries. Is it doable in powerbi?  

Thanks!

[lucafirefox]

@v-yalanwu-msft @amitchandak 
Thanks to both of you! I'm a newbie so I'm not proficient with measures creation. I implemented your solutions and my problem is finally solved. 

Best,

Luca

[v-yalanwu-msft · Accepted solution]

Hi, @lucafirefox ；

If you want to create a dynamic data, you have to create a measure, may be could try it:

Sale by client = CALCULATE(SUM([sales]),FILTER('Filter',[client]=SELECTEDVALUE('Filter'[client])))

The final output is shown below:

If this doesn't match your data, can you share a simple file and expect output results? It makes it easier to give you a solution.
Looking forward to your reply！

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.

[amitchandak]

@lucafirefox , you can not create a column with a slicer with a filter value.

You need measure

Client Value  = Sum(Table[Value])

Country Value all client = calculate(Sum(Table[Value]) , allexcept(Table, Table[country]) )