Forum Discussion
Column value depends on external filter
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
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-fc4095ae9afd
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
1 Reply
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-fc4095ae9afd
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