Forum Discussion

tzuchiao's avatar
tzuchiao
Regular Visitor
1 year ago
Solved

Using numeric range parameter in a column

Hi all, I am dealing with a dataset about student lateness, with the following columns: Day_x_Student_ID, Date, Student_ID, Late_min, Mentor_ID I wanted to create a Column to determine whether t...
Need Help
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    1 year ago

    Hello tzuchiao,

     

    Can you please try this approach:

    Count_Late_Days = 
VAR SelectedThreshold = SELECTEDVALUE(Late_Threshold[Late Threshold], 10)
RETURN
CALCULATE(
    DISTINCTCOUNT(StudentData[Day_x_Student_ID]),
    FILTER(
        StudentData,
        StudentData[Late_min] > SelectedThreshold
    )
)
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
1 year ago

Hello tzuchiao,

 

Can you please try this approach:

Count_Late_Days = 
VAR SelectedThreshold = SELECTEDVALUE(Late_Threshold[Late Threshold], 10)
RETURN
CALCULATE(
    DISTINCTCOUNT(StudentData[Day_x_Student_ID]),
    FILTER(
        StudentData,
        StudentData[Late_min] > SelectedThreshold
    )
)