Forum Discussion
Modify table comuns based on filters
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!
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.
3 Replies
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]) )
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.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
