Forum Discussion
How to create Parameter for User Input
Hi Spell
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi Spell - create a dax measure to reference the employee slicer as below:
in field parameters itself we can configure the below and set Data Type to Whole Number.
Set Minimum & Maximum values (e.g., 10000 to 99999 if applicable).
EE_Count =
VAR UserValue = SELECTEDVALUE(EmployeeInput[EmployeeInput])
RETURN
CALCULATE(
COUNTROWS(HRR082),
FILTER(
HRR082,
HRR082[L01 Person Number] = UserValue ||
HRR082[L02 Person Number] = UserValue ||
HRR082[L03 Person Number] = UserValue ||
HRR082[L04 Person Number] = UserValue ||
HRR082[L05 Person Number] = UserValue ||
HRR082[L06 Person Number] = UserValue ||
HRR082[L07 Person Number] = UserValue ||
HRR082[L08 Person Number] = UserValue ||
HRR082[L09 Person Number] = UserValue ||
HRR082[L10 Person Number] = UserValue ||
HRR082[L11 Person Number] = UserValue ||
HRR082[L12 Person Number] = UserValue ||
HRR082[L13 Person Number] = UserValue ||
HRR082[L14 Person Number] = UserValue
)
)
Hope this helps.
Thx of the input "create a dax measure" however that is the issue, I do not know how to create the measure which allows the user to input of select the value to be used? The value would be a specific EMPNO, so creating a slider does not really help, I need it to be a box where the number could be selected or typed in, not sure if that functionality exists?