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.

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

What if you use:

TOTALYTD(COUNT(BookingDataAir[Bookings]),'DimDate'​[full_date],ALL('DimDate'))
  • pankajdhillon's avatar
    pankajdhillon
    Frequent Visitor
    10 years ago

    Even that works same as TOTALYTD(COUNT(BookingDataAir[Bookings]),'DimDate'​[full_date]) i.e. no output :(

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      10 years ago

      What is the context in which you are using that measure?