What if parameter not working

[MP-iCONN]

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.

Status = IF(DrilldownB_1[Days] > 'Days Allowed'[Days Allowed Value],"Late","On-Time")

For some reason the slicer when set to any number will not change the values in Status correctly.

In the screen shot below you can see that for Days Allowed I have it sliced at 8 but then in the Days column for 6 and 7 it is marking them as Late when it should have made it On-Time.

 

Thank you for any help on this.

Chad

[oalgarvio]

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]

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]

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

[Jihwan_Kim · Accepted solution]

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.

[MP-iCONN]

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.