IF ISBLANK Function Showing Zeroes for Unrelated Matrix Columns

[bkoeppler]

Hello, 

I have a matrix which uses a hierarchy relationship that is joint across two dimensions. The milestone dimension allocates each System in the systemisation dimension a milestone from 1-5, the systemisation dimension then relates to 3 seperate fact tables. 

I would like the matrix to show all systems for each milestone and if there is no data for them, show the values as a zero.

When I don't use any DAX functions calling e.g. IF(ISBLANK(Calc),0,Calc), it only shows systems relevant to that milestone. However when I include an IF(ISBLANK) function, it shows every system under every milestone, even when not relevant.

[amitchandak]

@bkoeppler , when you +0 or kind handle blank, it starts doing left/full join in favor of dimension. So you will get all values.

To avoid that you have again remove values not needed

example of date range

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
if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1)