Display occurrences within a date range and number of occurrence slicer

[Anonymous]

Hi

I have this scenario, a table for Emergency Presentations looking like the sample below. I need to have a date range slicer and number presentations slicer. If my date rnage is between 1/8/2020 and 30/9/2020 and the presentation slicer is set to 2, I should only see patient B and C. IF the slicer for presentation set to 3, I should see patient A only. Thanks in advance, if anyone can help me build measures and/or relations for that .

[v-diye-msft]

Hi @Anonymous 

If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!

If not, please kindly elaborate more.

[amitchandak · Accepted solution]

@Anonymous ,

Use this measure with PatientID and selectedvalue(Value[value]) is value 1,2,3 which are selecting. Whatif or from independent table

countx(filter(summarize(Table,Table[PatientID], "_1", count(Table[Arrival Date])),[_1] >=selectedvalue(Value[value])),[PatientID])