Calculation with 2 datasets

[denzelg2g]

Hi,

I'm new to Power BI. So this might be an issue which can be found somewhere. Although I don't know how I would find it. 

My problem is the following:

I want to view data from Google Analytics>

I have a total amount of hits on a page, let's say 100

This page is a funnel wizard in which people choose an option. Let's say I got 3 options. option 1 is 20, option 2 is 30 and option 3 is 45, making a total of 95. The remaining number is the amount of people who skipped the question and didn't fill in any options. Now I want to display this in a pie chart, but I only have the 3 option's as metric. I have got the total (100) in a table. How can I connect, calculate and add the remaining (total - option 1,2 and 3) into the pie chart? Is that something I need to do with dax? I know that it can be done in Google Sheets but I would liek a direct connection with GA. 

Thank you in advance

[v-qiuyu-msft]

Hi @denzelg2g,

Could you please share some sample data you get from the Google Analystics? Also please share some screenshots about the desired resulsts for our analysis.

Best Regards,
Qiuyun Yu