Using numeric range parameter in a column

Hi tzuchiao ,

The issue you’re facing arises because calculated columns in Power BI are computed at the data model level and are static—they don’t dynamically respond to slicers or filters in reports. This is why your calculated column cannot use the dynamic Late Threshold Value from the slicer.

Why This Happens

• Static Nature of Calculated Columns: Calculated columns are computed once when the model is processed or refreshed. They do not recalculate based on slicers, filters, or user interactions in reports.
• Dynamic Behavior with Measures: Measures, on the other hand, are recalculated dynamically based on slicers and filters. However, measures cannot be used to create row-level evaluations directly within a column.

Option 1: Use a Measure Instead

Instead of a calculated column, you can use a measure to determine whether the student was late. Here's how:

1. Define the measure:

   Is_Late = 
   VAR Late_Threshold_Value = SELECTEDVALUE('Late_Threshold'[Late Threshold], 10)
   RETURN
   IF(
       MAX('Table'[Late_min]) > Late_Threshold_Value, 
       TRUE(), 
       FALSE()
   )

2. Use this measure in your visualizations. For example, you can count the number of late days per mentor using:

   Late_Days_Count = 
   COUNTX(
       FILTER(
           'Table',
           [Is_Late] = TRUE()
       ),
       'Table'[Day_x_Student_ID]
   )

   This avoids creating a static column and directly ties the logic to the slicer.

Option 2: Simulate Row-Level Evaluation with Measures

If you need mentor-level or day-level aggregations, create an additional measure to calculate the distinct count of late days:

Late_Day_Count = 
VAR Late_Threshold_Value = SELECTEDVALUE('Late_Threshold'[Late Threshold], 10)
RETURN
DISTINCTCOUNT(
    FILTER(
        'Table',
        'Table'[Late_min] > Late_Threshold_Value
    )
)

Option 3: Power Query Transformation

If slicer-based dynamic behavior isn’t mandatory, you can pre-compute the "Is_Late" column in Power Query by defining a threshold value (e.g., 10 minutes). You’ll lose slicer interactivity but avoid complexity:

1. Go to Power Query Editor.

2. Add a conditional column:

   • Name: Is_Late
   • Formula: if [Late_min] > 10 then "True" else "False"

3. Load the data back to Power BI.

Option 4: Use a Dynamic Calculated Table

If you want dynamic behavior with slicers but still need row-level filtering, you can create a calculated table with slicer-driven filtering:

1. Create a calculated table:

   Late_Students = 
   FILTER(
       'Table',
       'Table'[Late_min] > SELECTEDVALUE('Late_Threshold'[Late Threshold], 10)
   )

2. Use this table in visuals for mentor-level analysis.

Please mark this as solution if it helps you. Appreciate Kudos.