Forum Discussion

sunit1190's avatar
sunit1190
Icon for Helper I rankHelper I
3 years ago
Solved

Need help with stacked bar chart visual

Hi,   I have the following measure that calculates number of users for a given date range Count of users = CALCULATE (     DISTINCTCOUNT(MEETINGS_ADOPTION[USER_ID]),     FILTER (         MEETI...
Need Help
Tips and Tricks
  • sunit1190's avatar
    sunit1190
    3 years ago

    jdbuchanan71 I was able to make this work by creating multiple measures and then plotting them on the bar chart. Thanks for all your help!

sunit1190's avatar
sunit1190
Icon for Helper I rankHelper I
3 years ago

jdbuchanan71 Your measure solution got me close to what I want but I'm still missing one last step

 

In the screenshot below, I have filtered for the last 30 days and I accurately get count of 1on1s had by users under the highlighted leader on the bar chart as 18. However, the count of users who "Has not had 1on1" is 4 which is incorrect. For all the users under "Count of 1on1s" in the table that have value 0, I want to include them in this is bucket as well. 

 

 

 

Here is my updated DAX for the measure: 

Count of users =
CALCULATE (
DISTINCTCOUNT(MEETINGS_ADOPTION[USER_ID]),
(MEETINGS_ADOPTION[MEETING_DATE] >= MIN ( 'Calendar'[Date] ) &&
MEETINGS_ADOPTION[MEETING_DATE] <= MAX ( 'Calendar'[Date] )) ||
(MEETINGS_ADOPTION[MEETING_DATE] == BLANK() && MEETINGS_ADOPTION[MEETING_ID_W_R_DATE] == BLANK())
)

 

Any thourghts on how I can get to this?