How to show 0 instead of blanks(+0 adds other rows)

[MT22]

Hello,

I want 0 to be displayed for items with no data in my table instead of blanks. I prepared very simple data model:

 

The tables contain following records:

I created: 

• Measure = sum('Fact'[Value])
• With that measure I got following table

• What I want to achieve is to have 0 in the column measure for Montreal and Ottawa
• I tried to add "+0" to the measure but that gave all combinations:
• I aslo do not understand why there are also non-logical combinations like Canada-Los Angeles

Thanks for help

Regards

Marek

[amitchandak · Accepted solution]

@MT22 , After +0 force the filter again

example for date table

0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))

[MT22]

Hi @amitchandak thanks for your help. It works. 

Regards

Marek