Forum Discussion

lucafirefox's avatar
lucafirefox
Regular Visitor
4 years ago
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...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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's avatar
v-yalanwu-msft
Community Support
4 years ago

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.