Get count in filtered context

[Mahmed1]

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

 

 

[Mahmed1]

https://www.dropbox.com/scl/fi/wfnc4ou94yfvbmbhq5fg3/Test-File-Copy.pbix?rlkey=2kz4248k0dd5fmbgedcxh...

does this work?

[some_bih]

Hi @Mahmed1  I can see file. I will let you know what I can do.

[Mahmed1]

Thank you

[some_bih]

Hi @Mahmed1  check file version v2 for part occurance

For 16.12.2023 according to table there is only one row of entry

[Mahmed1]

Hey - For eg see this example file - tried amending with new data but used same measure you created

https://www.dropbox.com/scl/fi/tg69tbwwdtgk2qzc00lnj/Test-Latest-Examples.pbix?rlkey=1kqhx6f8t1qrdx8...

[some_bih · Accepted solution]

Hi @Mahmed1 

Check new file version 16122023

[Mahmed1]

PERFECT....Thank You

[Mahmed1]

Hey

even if i change to sumx or sum and comare that value against parameter i get incorrect result

It ahould check for total length per day for that category and then compare

so if i had 2 rows on 01/11 both 9 mins each (18 mins total) comparing against 15 mins in parameter box, that ahould be 1

If exactly the same on 02/11 then that would be another 1 so in total 2 occurences for both days

[Mahmed1]

Thank you for getting back to me

it doesnt quite work but think its on the same lines

for eg

say Blueberry category on the 

06/11 had a length of 13 twice so

06/11 13 Blueberry

06/11 13 Blueberry

and the parameter had 15 selected

the result in this case as the max is 13 will return a blank but its actually 26 the total length so should return a 1 

i get rather than the max in needs to look at the sum for that category and then compare it 

do i just need to change to Sum from Max?

[Mahmed1]

hi how do i send a file - says pbix not supported

[some_bih]

Hi @Mahmed1 please put some file or examples with inputs and expected output as you wish to have "correct" total and "play" with dates range.

[Mahmed1]

Hi any luck with this 

any help is appreciated