Forum Discussion
Mahmed1
Helper IV
Helper IVGet 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 i...
Mahmed1Helper IV
Helper IV- Mahmed1
Thank you
- some_bih
Community Champion
Hi Mahmed1 check file version v2 for part occurance
For 16.12.2023 according to table there is only one row of entry
- 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?