Blank result with TYD Calculation

[Anonymous]

Hi everybody 

I am trying to do a YTD calculation, the measure works well till it find a blank count in a date. The key points are:

Measure 

**bleep**. Count = 

CALCULATE (

TOTALYTD (

'Measures Table'[Count)], // The measure makes just a simple row count filter by some fields

DATESYTD ( 'Date'[CalendarDate] )

)

Result

I am getting the result show in the image below, however I would like to see in May a total of 17 and not blank. I've already tried adding a + 0 to the measure but I just get 0 in the **bleep**.Count for may. I already tried everything I have found on the forums but have not got my desired result.

Thanks a lot.

[amitchandak]

@Anonymous , the month name in the visual is coming from the date table? if not then its should come from that. Also, make sure you marked the date table as date table

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

[Anonymous]

Hi @amitchandak yes the month comes from the Date Table and the table is marked as date table

[amitchandak · Accepted solution]

@Anonymous , check one more thing. Join is single directional

If this does not help
Can you share a sample pbix after removing sensitive data.

[Anonymous]

Hi @amitchandak thanks a lot, the Cross Filter Direction of the relation was set to both I changed to single and it solved my problem. 

[amitchandak]

@Anonymous , Good it get solved.

There can 6 reasons - Listed in this blog-https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

Use Date Table (Join with Fact Date)
The date table is marked as a date table
Use columns from the date table
The date does not have a timestamp
The date table has all dates

Other than these, bidirectional join with date table can also cause failure, because this can filter dates on date table and we might lose continuous dates.