Forum Discussion
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...
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.
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