Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Blank result with TYD Calculation

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.

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , check one more thing. Join is single directional

     

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

5 Replies