Forum Discussion

MP-iCONN's avatar
MP-iCONN
Icon for Resolver I rankResolver I
4 years ago
Solved

What if parameter not working

I am trying to have a user input What If Parameter that will input a number into a measure and return a text value.   For example I created a What If Parameter from 0 to 20 and called it Days Allow...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, I think the STATUS is created as a column, right?

    Instead of setting up the Status Column in the table as a calculated column, please try to create a calculated measure. And then, it will be dynamically change.

    Thank you.

oalgarvio's avatar
oalgarvio
Frequent Visitor
2 years ago

I'm struggling with the same problem. How have you created a measure instead of a column? I'm getting the error "A single value for column 'A' in the table 'table1' cannot be determined (...)" 

Measure = IF( table1[A] >= parameter[parameter value],1,0)
  • MP-iCONN's avatar
    MP-iCONN
    Icon for Resolver I rankResolver I
    2 years ago

    I used a measure.

     

    My What if Parameter is called Days Allowed with a range of 0 to 80 with a default value of 5.  Then my table is called DrilldownB_1.   My measure is called Status...

     

    Status = IF(SUM(DrilldownB_1[Diff]) > 'Days Allowed'[Days Allowed Value],"Late","On-Time")
    • oalgarvio's avatar
      oalgarvio
      Frequent Visitor
      2 years ago

      Ah, you are using a SUM. I believe that doesn't work for me. I really need to use a column. I created a post with my problem  feel free to comment if you have anything to add. Thank you