Count how many patients visit x number of times

[HeidiTr]

I have a list of hospital visits for 2020 and have been asked to visualize how many patients have had 1, 2, 3, etc. visits in each department. I'm getting myself rather counfused while WFH, but I think I need to count a count - right? Can someone help me formulate this? 

I have [Visit ID], [Patient SSN] and [Department]. I want the overall results, and then I'll just filter on each Department later on. I am expecting to get something like this:

13.340 patients had 1 hospital visit

15.993 patients had 2 hospital visits

7.902 patients had 3 hospital visits

...etc.

Thanks in advance,

Heidi

[v-janeyg-msft]

Hi, @HeidiTr 

Can you share some fake sample data and your desired result ? And What visuals you want to use to display the result? So we can help you soon.

Best Regards

Janey Guo

[HeidiTr]

Dear Janey, thank you. I figured it out myself, with inspiration from amitchandak's answer. I've accepted his answer as the "solution" now.  

Best, Heidi 

[v-janeyg-msft]

Hi @HeidiTr ,That's OK, I am glad you can solve it by yourself.

Best Regards

Janey Guo

[amitchandak · Accepted solution]

@HeidiTr , I think you need bucketing on a visit measure using independent table, Post that you will be able to create %.

Check if my video can help : https://youtu.be/CuczXPj0N-k

or

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization