# How to dynamically change column that is used for a measure based on a filter/parameter

**URL:** <https://community.holistics.io/t/how-to-dynamically-change-column-that-is-used-for-a-measure-based-on-a-filter-parameter/678>\
**Category:** Ask the Community\
**Tags:** aml\
**Created:** [January 18, 2022, 8:12am UTC](https://community.holistics.io/t/how-to-dynamically-change-column-that-is-used-for-a-measure-based-on-a-filter-parameter/678 "2022-01-18T08:12:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mabr](https://community.holistics.io/user_avatar/community.holistics.io/mabr/32/407_2.png) [@mabr](https://community.holistics.io/u/mabr)\
**Post date:** [January 18, 2022, 8:12am UTC](https://community.holistics.io/t/how-to-dynamically-change-column-that-is-used-for-a-measure-based-on-a-filter-parameter/678/1 "2022-01-18T08:12:25Z")

</div>

Hi  
We have built 4 different attribution models for our website data. My goal is to build dashboards, where there is a filter/parameter/attribute where the user can choose their preferred attribution model.

The logic would be as follows in the aml code:

I have 4 hidden dimensions for each of the attribution models.  
I have a measure defined with aml code, where I use a case when statement to select between the different dimensions to sum.

I cannot figure out how to define the variable that contains the selected attribution model.  
Essentially I am looking for something similar to what you can do in Looker with parameters: [parameter &nbsp;|&nbsp; Looker &nbsp;|&nbsp; Google Cloud](https://docs.looker.com/reference/field-params/parameter)

btw, is there a full documentation somewhere of all possible things to do with aml code (a repo or something similar)? I find the documentation to be a bit limited still.

---

<div class="post-metadata">

**Author:** ![anthonytd](https://community.holistics.io/user_avatar/community.holistics.io/anthonytd/32/374_2.png) [@anthonytd](https://community.holistics.io/u/anthonytd)\
**Post date:** [January 22, 2022, 3:48pm UTC](https://community.holistics.io/t/how-to-dynamically-change-column-that-is-used-for-a-measure-based-on-a-filter-parameter/678/2 "2022-01-22T15:48:24Z")

</div>

Thanks for sharing @mabr . Unfortunately, we don’t support this at the moment. However, this feature is highly prioritized in our roadmap for 2022.

We created a feature suggestion topic to discuss more use-cases, please feel free to upvote or share your feedback

> [@Query Parameters for Dynamic Dimensions, Measures, and more](https://community2.holistics.io/t/query-parameters-for-dynamic-dimensions-measures-and-more/686):
>
> Update: See upcoming feature announcement of [Dynamic Models](https://community2.holistics.io/t/upcoming-launch-dynamic-models-aka-query-parameters/1341). Problems and Use-cases Dynamically modifying the query result returned from data exploration according to dashboard input. Use-cases [How to dynamically change column that is used for a measure based on a filter/parameter](https://community2.holistics.io/t/how-to-dynamically-change-column-that-is-used-for-a-measure-based-on-a-filter-parameter/678)[More Control on Dashboard Date Filters - Feature Suggestions](https://community2.holistics.io/t/more-control-on-dashboard-date-filters/706/2)[Accepting user input variables in reports in 2.7 / 3.0](https://community2.holistics.io/t/accepting-user-input-variables-in-reports-in-2-7-3-0/495) Create Reusable Fitler Group - [Reusable filters - aka filtergroups](https://community2.holistics.io/t/reusable-filters-aka-filtergroups/705)[More Control on Dashboard Da…](https://community2.holistics.io/t/more-control-on-dashboard-date-filters/706/6)

---

<div class="post-metadata">

**Author:** ![mabr](https://community.holistics.io/user_avatar/community.holistics.io/mabr/32/407_2.png) [@mabr](https://community.holistics.io/u/mabr)\
**Post date:** [January 24, 2022, 8:14am UTC](https://community.holistics.io/t/how-to-dynamically-change-column-that-is-used-for-a-measure-based-on-a-filter-parameter/678/3 "2022-01-24T08:14:40Z")

</div>

Sounds good. Looking forward to the release of this feature

---

<div class="post-metadata">

**Author:** ![thanh](https://community.holistics.io/user_avatar/community.holistics.io/thanh/32/53_2.png) [@thanh](https://community.holistics.io/u/thanh)\
**Post date:** [June 28, 2024, 5:23am UTC](https://community.holistics.io/t/how-to-dynamically-change-column-that-is-used-for-a-measure-based-on-a-filter-parameter/678/4 "2024-06-28T05:23:15Z")

</div>

The specific instruction for this use case can be found [here](https://community2.holistics.io/t/creating-dynamic-dimension-with-query-parameters/1978)
