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 ( ...
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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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.