Forum Discussion
Get count in filtered context
Hi
I hope you are all well
I have a slicer where i can select a date range and a parameter box where i can filter anything above whatever is this parameter value
what i am trying to do is get the rows of any activity that is >= to the parameter value
I set a measure like this
check act value = If(tbl_my_act[activity]>=Parameter[parameter_value],1,0)
I then added this to my matrix and on filtered page view filtered to 1
the problem i am having is that it pulls back all records that meet criteria but the total is not right
so if
there are 4 records that meet the criteria
ie
name. Act
John 20
Henry 20
Joe 20
Harry 20
80
if i drag in the measure check act val the total shows 1 and not 4
i also need a seperate measure that looks at the date range and gives the number of times its met the criteria per day
so if i selected 04/12 to 06/12
agent 1 3
agent 2 = 2
agent 3 = 1
so agent 1 met the criteria on all 3 days
agent 2 only twice etc
hope this makes sense
the results should show what is in textbox which i typed in manually
in example below - a is when condition was met
As you can see matrix does not give right total