cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver I

## 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.

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.

1 ACCEPTED SOLUTION
Super User

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.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

5 REPLIES 5
Frequent Visitor

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)
Resolver I

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")
Frequent Visitor

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

Super User

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.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

Resolver I

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors