Forum Discussion
Solved
Filtering with a measure
Good Afternoon,
I have the below measure for calculating if an employees training is still valid after a selected date.
training_valid=
VAR _SelectedDate = max('Date'[Date])
VAR _Result = IF( MAX('employee_training'[training_expiry_date])>= _SelectedDate, "Valid", "Expired")
RETURN
_Result
This works perfectly well, what i now want to be able to do is create a card/measure for the number of employees that are working on the selected date and also where the training is valid.
I cant seem to add the above measure in as a filter on a card or a table if iuse a measure of
I cant seem to add the above measure in as a filter on a card or a table if iuse a measure of
Total Working=
Calculate(
distinctcount ('employee'[employee_number]),
'employee_rota'[rota] = "working")
Is it possibe to filter using the measure for valid training
Is it possibe to filter using the measure for valid training
Thank you
maurcoll You should be able to add a measure in the Filters pane at the visual level.
2 Replies
maurcoll You should be able to add a measure in the Filters pane at the visual level.
Hi I need to appy the filter to a card visual, it does not let me do this. This is all i see and it does not let me enter anything into the contains box.
