aggregation without filter context

[Anonymous]

Hi,

I am working on a matrix visulisation and my idea is to plot the start of activitiy based on user_id's. The values in the x axis are year,month and user_id. The y axis has day (1-31). I was able to plot the start date for individual user_ids. I used min(start date) and compared it with calendar() function to plot the values. "1" denotes activity 1 start and end date whereas  "2" denotes activity 2 start and end date.

The issue that I am facing is, I want to plot the values with just the year, months on x-axis and not use individual user id's. Is there any way to do this? For eg, I tried plotting jan month in x-axis but when I use just months, it is aggregating all the activity values in the month of january instead of getting each instance of the activity. Can someone suggest any solution for this?

Source:

Current Output:

Expected Output:

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Pls refer the following ,create a measure,and a day table:

Measure = COUNT('Table'[ID])

Then create visual:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien