topic Re: Get count in filtered context in DAX Commands and Tips

Get count in filtered context

Mahmed1 — Fri, 08 Dec 2023 17:10:50 GMT

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

name. Act

John 20

Henry 20

Joe 20

Harry 20

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

Re: Get count in filtered context

Mahmed1 — Sat, 09 Dec 2023 03:04:35 GMT

Hi any luck with this

any help is appreciated

Re: Get count in filtered context

some_bih — Sat, 09 Dec 2023 10:41:34 GMT

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.

Re: Get count in filtered context

Mahmed1 — Sat, 09 Dec 2023 11:12:52 GMT

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

Re: Get count in filtered context

Mahmed1 — Sat, 09 Dec 2023 11:18:07 GMT

https://www.dropbox.com/scl/fi/wfnc4ou94yfvbmbhq5fg3/Test-File-Copy.pbix?rlkey=2kz4248k0dd5fmbgedcxhaiq7&dl=0

does this work?

Re: Get count in filtered context

some_bih — Sun, 10 Dec 2023 20:35:04 GMT

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

Re: Get count in filtered context

Mahmed1 — Sun, 10 Dec 2023 20:49:38 GMT

Thank you

Re: Get count in filtered context

some_bih — Mon, 11 Dec 2023 13:00:14 GMT

Hi Mahmed1 check file version v2 for part occurance

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

Re: Get count in filtered context

Mahmed1 — Mon, 11 Dec 2023 14:32:24 GMT

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

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?

Re: Get count in filtered context

Mahmed1 — Mon, 11 Dec 2023 14:48:40 GMT

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

Re: Get count in filtered context

Mahmed1 — Mon, 11 Dec 2023 16:21:20 GMT

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=1kqhx6f8t1qrdx8e442ryaol0&dl=0

Re: Get count in filtered context

some_bih — Sat, 16 Dec 2023 14:52:20 GMT

Hi Mahmed1

Check new file version 16122023

Re: Get count in filtered context

Mahmed1 — Sun, 17 Dec 2023 20:27:55 GMT

PERFECT....Thank You