Forum Discussion

pankajdhillon's avatar
pankajdhillon
Frequent Visitor
10 years ago
Solved

TOTALYTD not working

I am using TOTALYTD but no output is coming from it TOTALYTD(COUNT(BookingDataAir[Bookings]),'DimDate'[full_date])   whereas when I use CALCULATE it works fine and gives expected result CALCULATE...
  • pankajdhillon's avatar
    pankajdhillon
    10 years ago

    Actually I realized my mistake, my formula was correct but when I was trying to visualize my data I was using date column from my BookingDataAir dataset rather than using them from DimDate dataset and due to that no value was coming for TOTALYTD. 

     

    Thanks everyone for help though.

     

pankajdhillon's avatar
pankajdhillon
Frequent Visitor
10 years ago

Actually I realized my mistake, my formula was correct but when I was trying to visualize my data I was using date column from my BookingDataAir dataset rather than using them from DimDate dataset and due to that no value was coming for TOTALYTD. 

 

Thanks everyone for help though.

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    DAX is all about context! :)