Forum Discussion
Helper IIssues in developing 100% stacked column chart visual
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
2 Replies
- amitchandak
Super User
Praj , You measure should be like
divide(Distinctcount(Fact[UserID]), calculate(Distinctcount(Fact[UserID]), all(Fact)) )
PrajThanks 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
