Issues in developing 100% stacked column chart visual

[Praj]

Hey Everyone,

I have the below input tables, in which 1st table has the user details and 2 table has user details, activity conducted by user and date of activity.

Table 1

Table 2

I am trying to identify the % of total user who had activities in a specific month/quarter using a slicer as shown in the below image.  For example, In April 2023, only 1 user is scheduled to have an activity and the output in the visual am expecting is 10% as there is only 1 user out of 10 total user who has activity in April. However, the stacked column chart when I use, It shows 100% all the time.  Can anyone please let me know how I can get this. 

I know this is pretty basic, but I don't know where I am missing to get the results.

Looking for any approach or solution to get the desired results.

TIA

Cheers,

Praj

[amitchandak]

@Praj , You measure should be like

divide(Distinctcount(Fact[UserID]), calculate(Distinctcount(Fact[UserID]), all(Fact)) )

[Praj]

Thanks @amitchandak for your response. 

I did try the above measure and added that to chart however, the chart still displays the same result as 100% everytime

Cheers,

Praj