Forum Discussion
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 Allowed and added it as as slicer with a default value of 5.
In my Table then I created a column that will look to any values greater than "Days Allowed" and mark Late or On-Time.
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.
5 Replies
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.
Thank you! For some reason I thought I needed to make that Status a calculated column but sure enough once I changed it to a measure that worked! Thank you.
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)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")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
