Ribbon Chart - Calculate % by legend

[Anonymous]

Hello,

I am trying to create a ribbon chart that shows a change in population as time increases. My Ribbon chart currently displays a count of the population by a value on the x-axis (time groupings (e.g. less than 30 mins, 30mins-1hour etc.), and is split by a priority order (1-5).

This leaves me with 5 ribbons moving across horizontally. However, one of the priority buckets has a higher population and therefore appears higher at time intervals when it proportionally isn't.

What I want to do is something like:

COUNTA(POPULATION) [grouped by priority and time block (done via chart at present)]

DIVIDED

COUNT OF PRIORITY

This would mean I would have 485 display as 485/COUNT(Population for priority 3)

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Percentages-to-multi-line-report/m-p/378504#M172040

[Anonymous]

Thanks that post helped me fix it. Using the formula in the post I got this:

Measure = DIVIDE(
SUM('Generic ED Data'[POPULATION]),
CALCULATE(SUM('Generic ED Data'[POPULATION]),ALLSELECTED('Generic ED Data','Generic ED Data'[Priority])))

However, this created a stacked column chart, which, whilst useful isn't exactly what I wanted.

I then used the following formula:

Measure 2= DIVIDE(
SUM('Generic ED Data'[POPULATION]),
CALCULATE(SUM('Generic ED Data'[POPULATION]),ALLEXCEPT('Generic ED Data','Generic ED Data'[Priority])))

which got me the result I wanted. Using ALLEXCEPT on timing showed which priority group had the most people leaving.  The other method just showed a % for each axis point as well. Which is useful if I want to see which proportion of the priority group left for each time.