Show blank as zero without extra measure/ utilizing the default visualisation aggregation selections

[Applicable88]

Hello,

I'm using a matrix with a dimension as rows:

	Counts	Position		TotalRevenue
Post
Direct	50	3		1000
Total

I know using If-statements or adding a "+0" in a count measure can solve this problem, but I try to stick with 

the standard aggregation function for the tables without an extra mesaure. When PowerBi recognized it as a Number- Datatype I already have plenty of aggregation for selection. Here depending on column I used count or sum . In the row properties I already clicked that it should show also empty values. But as you see its blank instead of zero.

Is it possible without a extra measure to change it?

Thank you very much in advance. 

[Anonymous · Accepted solution]

HI @Applicable88,

In fact, 'if statement' and '+0' on the expression not work to handle records that not really existed in your table.
For this scenario, you need to create a not connected to the raw table and use its fields to replace raw table categories. Then you can use Dax expression to extract the current data and compare it with if statements.

Regards,

Xiaoxin Sheng

[AlexisOlson]

Nope. Blanks and zeros are not the same. You'll need measure(s) to do the conversion.

[jdbuchanan71]

@Applicable88 

No, it is not possible to show 0 instead of blank using the default aggregations.