Forum Discussion

Mahmed1's avatar
Mahmed1
Helper IV
2 years ago
Solved

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

 

 

12 Replies