topic Re: Issues in developing 100% stacked column chart visual in DAX Commands and Tips

Issues in developing 100% stacked column chart visual

Praj — Mon, 23 Jan 2023 11:59:43 GMT

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

Re: Issues in developing 100% stacked column chart visual

amitchandak — Mon, 23 Jan 2023 12:07:39 GMT

Praj , You measure should be like

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

Re: Issues in developing 100% stacked column chart visual

Praj — Mon, 23 Jan 2023 12:22:43 GMT

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