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
