Showing a row where no value exists

I have a list of 5 countries we sell products to. And we split it into 3 product categories: internet, consulting services, phone.

I have used power query to and loaded the connection into the data model, but not as a table within a worksheet.

These are my total sales amount pivot tables:

Filter: USA

phone | 500 mill

Consulting | 20 mill

Internet | 30 mill

Filter: New Zealand

Phone | 5 mill

Internet | 20 mill

Problem: I need New Zealand to show Consulting and a sales amount of 0.

There is no “consulting” row in the source data itself for New Zealand so “show zero values” in pivot table settings doesn’t work

I figure I’ll need to create my own tables listing: Phone, Consulting and Internet as row headings. But how should I get my sales sums?

I’m guessing doing xlookups using my pivot table is the data source is not best practice

Do I scrap my pivot tables and load the power query as a table for sumif?