Column value depends on external filter

[David1205]

Hello all,

I have the following table structure:

Column 1: Sales figures Germany
Column 2: Sales figures USA
Column 3: Sales figures UK

In the report, there should be an external filter (not linked to my table) that can be used to filter by Germany/USA/UK.

Using DAX I would like to add a new column (column 4) in my table which, depending on this external filter, will either take the value from column 1, column 2 or column 3.

Do you have any experience with such a problem?

Thanks for your help!

David

[amitchandak · Accepted solution]

@David1205 , nor very clear, what do mean by the external filter. You can use field parameter in this case

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf