Percent of total of day per status

[slav84]

Hello, 
I have a table that looks like this:

What I need to do is to calculate % of status of total for the day and plot it on stacked bar chart. 

So basically for 10-25th i would have

I tried doing this:

 but obviosuly thesenumbers are not correct. It is bar chart it showes by status however what is doing is taking %GT Count as percent of total of all data not as total of particular day. 

How do i fix this?

[MahyarTF · Accepted solution]

Hi,

Please try the below code to create the measure and use it in your visuals :

% Of Total For 25th = DIVIDE(SELECTEDVALUE(Sheet249[Count]),

                             CALCULATE(sum(Sheet249[Count]),

                                       filter(all(sheet249),

                                              Sheet249[ReportDate] = SELECTEDVALUE(Sheet249[ReportDate])

                                            )

                                    )

                            )

Appreciate your Kudos an please mark it as solution if it helps you

[Freeseman]

You will need to make sure your value is decimal number in your transform table. Eg 

Then for example, click your field:

Column tools, select Percentage decimal 2 maybe?

And Result