Slicer doesn't show column with zero value

[mmparvez]

I have a simple table

A matrix with a slicer shows: 

But on the 20 January it shows only male: 

But i like to see it with "F" column with 0 values. How can i do that?

[Data-estDog]

Try this: CLick on the matrix. Click on the V next to fields you want to show

[mmparvez]

I did:

But the result is same.

[Data-estDog]

Then you have two options. Separate the Sex column into its own dimension:

Or fill in the missing entries with Zeros

I split into separate Dimension and it works: 

Matrix Settings:

Well.. doesn't show a 0... just blank. 

Be sure to mark as solution if this provided the answer. 

[mmparvez]

Thanks @Data-estDog . But on YTD shows no value for F.

YTD = TOTALYTD(SUM('Sheet1'[Value]), 'Sheet1'[Date].[Date], 'Sheet1'[Date]<= SELECTEDVALUE(Sheet1[Date]))

[Data-estDog]

Fair enough. One more trick. Instead of adding an implicit measure, add and explicit measure and correct for isblank: 

[mmparvez]

Can you please explain. How can i do it with YTD measure? YTD of 20 January should show the F value 30 not 0.

[Data-estDog · Accepted solution]

Just wrap it around the main expression:

YTD = TOTALYTD(
   IF(ISBLANK(SUM('Sheet1'[Value]),0,SUM(Sheet2[Value]))
  ,'Sheet1'[Date].[Date]
  ,'Sheet1'[Date]<= SELECTEDVALUE(Sheet1[Date])
)