Calculating distinct count of IDs by grouping of data elements

[gcrisp]

I am in working in pharmacy claims data.  I am trying to use the raw data to create a visual which would be able to group the number of member IDs that fall within a range of # of prescriptions.  For example, how many distinct members received 1-5Rx vs 6-10 rx, etc. Here is a sample of the visual and the raw data.

Sample data: 

Drug	Member ID	Rx Count
A	1	1
B	2	1
A	3	1
C	3	1
A	2	1
B	1	1

[gcrisp]

@amitchandak thank you for the assistance!  That worked! 

[amitchandak · Accepted solution]

@gcrisp , I think you need

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k