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
    11 months 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



iadbmd's avatar
iadbmd
Frequent Visitor
1 year ago

Will this allow me to analyze an existing table, which is imported using a query, and calculate variables while the users select desired values using the slicer? My current issue is that the calculations are not changing to the newly selected numbers from the dropdowns.

Example: Say the table is 1000x20. I need to evaluate: 

Result = 

If (Var1 == "Active" & Var3 == "Green"), G_Active

ElseIf(Var1==Ïnactive"& Var3=="Green"), G_Inactive
and so on...

The values G_Active and G_Inactive need to be dynamic values that the user can change, preferably using a dropdown. I have a slicer for those. I cannot add a new column to the table because that is static, so it will not react to the slicer. This is an example of the calculation I need to make:

1.1 Status =
VAR _phase = SELECTEDVALUE(Table1[Phase])
VAR _type  = SELECTEDVALUE(Table1[oper_typ_cd])
VAR _option1 = 'Parameter1'[Parameter1 Value]
VAR _option2 = 'Parameter2'[Parameter2 Value]
VAR _option3 = 'Parameter3'[Parameter3 Value]
VAR _option4 = 'Parameter4'[Parameter4 Value]

VAR result = SWITCH(
    TRUE(),
    _type = "Green" && _phase = "Active", _option1,
    _type = "Green" && _phase = "Inactive",   _option2,
    _type = "Blue" && _phase = "Active", _option3,
    _type = "Blue" && _phase = "Inactive",   _option4,
    0
)
RETURN result
 
The options were created using New Parameter.
v-aatheeque's avatar
v-aatheeque
Community Support
1 year ago

Hi iadbmd 

Just checking in to see if your issue has been resolved. Were you able to implement the suggested approach and get the expected results?

 

If everything’s working now, that’s great!  If not, feel free to share any updates  I’m happy to help further.

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    1 year ago

    Hi iadbmd 

    Just wanted to check on the current status of your issue.


    Were you able to implement the suggested approach successfully, or are you still facing any issues.
    Let us know where things stand  we’re happy to assist further if needed.