Calculating a percentage based on a subset of records

[Scubadiver007]

Hi,

I have a column for primary need and a column for the support type.

What I would like to do is calculate the percentage of each primary need for those with an EHCP and those with SEN support separately, rather than for both combined, but I'm not sure how to do it. See below for an example.

[Scubadiver007]

I have this visual on the page and all the percentages add up to 100%, but this is not what I want. I would like the bars only for SEN support to add up to 100%, likewise for EHCP.

I can do this easily enough in a matrix but not sure if I want to. I think I could probably put it into a bar chart if I unpivot the data, but I don't want to due to other analysis.

[Anonymous]

Hi @Scubadiver007,

Create a measure that calculates the percentage relative to the total number of pupils within each Support Type only.
This will reflect the distribution of primary needs within each support category as intended.

Regards,

Vinay Pabbu

[Scubadiver007 · Accepted solution]

This is what I couldn't figure out, but I have come up with a simpler solution. Just create two separate charts and filter them.

[Anonymous]

Hi @Scubadiver007,

Thank you for sharing your update. i request you to please accept your own post as the solution, this will help other community members who might face a similar issue.

Regards,

Vinay Pabbu

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?