Forum Discussion
Solved
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 clien...
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.
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]) )