Creating a chart with a Percentage based on the sum of two filtered values from another chart

[JWorthy]

Hello,

I'm really new to PowerBI and don't know any DAX yet 😞

I'm trying to create a column visual which shows values as a percentage of the sum of two values from another chart.

I've run a survey.

1. Chart 1 shows those who answered 'Strongly agree - Strongly disagree' to question 1
2. Chart 2 shows answers to question 2, a multiple check box question where you could choose multiple answers.
3. I want to show each option in Chart 2 as a percentage of those who answered 'Strongly agree' + 'Agree' to question 1

How do I do this?

question 2 - chart 2Question 1 - chart 1

Thank you very much for your help! 🙂

J

[v-huizhn-msft]

Hi @JWorthy,

It's hard to give specific solution without sample data as @davehus said. So you can create some fake data if your data is private.

Thanks,
Angelia

[JWorthy]

Hi @v-huizhn-msft and @davehus

I've attached some sample data. Thank you very much for your help!

Below is a onedrive link to some sample data.

https://1drv.ms/x/s!AjuHMtVQGOB-hz2pVR-p_GLHy5lY

J

[v-huizhn-msft]

Hi @JWorthy,

Please create two measures using the formula and add it in clusted column chart, you will get expected result as follows.

Percentage1 = DIVIDE(COUNT('Question 1'[Response]), CALCULATE(COUNTROWS('Question 1'),ALL('Question 1')))

count = COUNT('Question 2'[Response])

You can download the .pbix file for more details.

Best Regards,
Angelia

[JWorthy]

Hi @v-huizhn-msft,

Thanks for coming back to me.

I'm trying to do something slightly different. In the second chart, instead of calculating a % of the question 2 responses, I'd like to calculate the question 2 response as a % of 2 of the question 1 responses.

I'd like the second chart to show:

% of respondents who have chosen option A, B, C & D =

(Number of respondents who have chosen option A, B, C & D for question 2)

/

((Number of respondents who have selected option x for question 1)

+

(Number of respondents who have selected option y for question 1))

Does that make sense?

Thanks,

J

[davehus]

Hi - Have you got some sample data that you could provide?

Thanks