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.
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