How can I create a measure to bucket users into 3 different categories based on other measures?

[sunit1190]

Hi,

I have a table below which contains 'count of meetings' and 'count of meetings with ratings' for each user. These columns are measures and here's the DAX:

Count of 1on1s =
CALCULATE (
DISTINCTCOUNTNOBLANK(MEETINGS_ADOPTION[MEETING_ID])+0,
FILTER (
MEETINGS_ADOPTION,
(MEETINGS_ADOPTION[MEETING_DATE] <= MIN ( 'Calendar'[Date] )
&& MEETINGS_ADOPTION[MEETING_DATE] >= MAX ( 'Calendar'[Date] )) ||
(MEETINGS_ADOPTION[MEETING_DATE] >= MIN ( 'Calendar'[Date] ) &&
MEETINGS_ADOPTION[MEETING_DATE] <= MAX ( 'Calendar'[Date] ))

)
)

Count of 1on1s with rating =
CALCULATE (
DISTINCTCOUNTNOBLANK(MEETINGS_ADOPTION[MEETING_ID_W_R])+0,
FILTER (
MEETINGS_ADOPTION,
(MEETINGS_ADOPTION[MEETING_ID_W_R_DATE] <= MIN ( 'Calendar'[Date] )
&& MEETINGS_ADOPTION[MEETING_ID_W_R_DATE] >= MAX ( 'Calendar'[Date] )) ||
(MEETINGS_ADOPTION[MEETING_ID_W_R_DATE] >= MIN ( 'Calendar'[Date] ) &&
MEETINGS_ADOPTION[MEETING_ID_W_R_DATE] <= MAX ( 'Calendar'[Date] ))

)
)

I want create a measure that will allow me to count the number of users and bucket them into 3 categories namely 'Has had 1on1' , 'Has had 1on1 with rating' and 'Has not had 1on1' dynmically based on the date slicer range on the report which I have setup using calendar table. 

Example of what I'm trying to achieve:

Under Mike - there are total 46 users and per the table 17 users have count of 1on1s >0, no users have count of 1on1s with ratings >0 and total users that have not had 1on1s is 29(46-17) in the last 30 days. I want to show this distribution on the bar chart below and it have it change dynamically when I change the date filter to say last 60 days. 

Any help or pointers on how I can achieve this? 

[Ashish_Mathur]

Hi,

Not clear on what the input data is.  Share some data in a format that can be pasted in an MS Excel file and show the expected result.  How does one know whether the meeting is 1 on 1 or whether the meeting is 1 on 1 with rating?  Is there a column which says so.

[sunit1190]

Hi @Ashish_Mathur , I have two columns namely MEETING_ID and MEETING_ID_W_R in my dataset that I'm using in the above measures to get counts of meetings

What I'm struggling to do is count meetings when they don't fall in the selected date range and bucket them into a "Has not had 1on1" category.

Is there a way to setup a measure that will let me setup 3 buckets and also then be able to plot it on the bar graph as I have mentioned above?