Forum Discussion

iadbmd's avatar
iadbmd
Frequent Visitor
1 year ago
Solved

How to create conditional variable with dynamic values?

Context: I have a table which is connected in Power BI through a query. I am creating a dashboard for users which test scenarios by adjusting a number of parameters (50+) using dropdowns to set value...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    Hi iadbmd 

    To help me reproduce your scenario and better understand why the slicer selections aren’t affecting the measure, could you please share a small but representative sample dataset in a usable format.

    Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
    Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

    Please show the expected outcome based on the sample data you provided.

    How to provide sample data in the Power BI Forum - Microsoft Fabric Community



FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

One these variables are setup, what do you want to do with them?

  • iadbmd's avatar
    iadbmd
    Frequent Visitor
    1 year ago

    The new variables (Value_1, Value_2 etc.) are used in other calculations downstream. My table is larger in reality. It contains identifiers such as Country and Year. I then aggregate the Values by Country-Year and take some averages to display.

  • iadbmd's avatar
    iadbmd
    Frequent Visitor
    8 months ago

    Hello,

    After a long time I have provided a sample table from my dataset in the posts' body. I included examples of what I want to calculate as well.