How to SUM 'Count' value and show percentage

[tonton]

I have a data something like this:

and I want to achieve this kind of table report in my dashboard.

If you notice in my table report above, there are BRAZIL and JAPAN that doesnt have any product ID, I also want to show this.

What I did so far is to create a new data source with the list of ALL Country and merged it with my Product Sales list

For the Order ID Count, what I did is to create a measure

Order ID Count = COUNT(Merge1[tblSales.Order ID]))

now my question is how to show the percentage? because if I add Order ID Count column as value an select 'Show value as percentage of grand total', BRAZIL and JAPAN won't be shown in the table

any idea to show BRAZIL and JAPAN as 0 and percentage of the 'Count'?

[v-yingjl]

Hi @tonton ,

Glad to hear the issue is solved. You can accept the suitable reply as solution, that way, other community members could easily find the answer when they get same issues.

Best Regards,
Yingjie Li

[amitchandak · Accepted solution]

@tonton , Add +0 to your Measure

[tonton]

woah that was fast. actually I saw in some post/discussions adding +0 somewhere but not really sure exactly where. thanks for this info. it now works!