Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Advocate I

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

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

5 REPLIES 5
Microsoft Employee

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

Advocate I

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

Microsoft Employee

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

Advocate I

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

Memorable Member

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

Thanks

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors