power bi calculate percentage based on category

[thotwielder]

For the table below, I would like to get the percentage of success_run / total run_count for each day. e.g. for Jan 23, for tm get 2/5, and for crm get 1/5. The bar chart should show 40% and 20% respectively for tm and crm on Jan 23.  And yes the total is 60 %, instead of 100% for Jan 23.

Sorry can't figure out how to post a photo

https://imgur.com/a/MsE6tYq

[Anonymous]

Use 100% Stacked Column Chart.

[v-chuncz-msft · Accepted solution]

@thotwielder,

You may use measure below.

Measure =
DIVIDE (
    SUM ( Table1[success_run] ),
    CALCULATE ( SUM ( Table1[run_count] ), ALLSELECTED ( Table1[source] ) )
)