Forum Discussion

Nemes's avatar
Nemes
Frequent Visitor
8 years ago
Solved

Issues with measure using time intelligence

Hello,   I've been running into issues when creating measures, particularly with time intelligence (for example SAMEPERIODLASTYEAR).   Here is a stripped down version of my report, with only the ...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Nemes

     

    How about this one

     

    Total Amount Last Year =
CALCULATE (
    [Total Amount],
    SAMEPERIODLASTYEAR ( 'Dates'[Date] ),
    ALL ( Dates )
)
Nemes's avatar
Nemes
Frequent Visitor
8 years ago

Hi Zubair_Muhammad,

 

This does work without filters, but it does not work as well once I use some filters. For example, if I want to see just 2015 and 2016, the "Total Amount Last Year" for 2015 will be blank, even though there were amounts in 2014.

 

Even if I was not filtering on years, it's bizarre that I would need to resort to ALLEXCEPT, whereas the Contoso sample report works without ALLEXCEPT. Would you have any ideas why there is a difference?

 

And thank you for your assistance.

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Nemes

 

How about this one

 

Total Amount Last Year =
CALCULATE (
    [Total Amount],
    SAMEPERIODLASTYEAR ( 'Dates'[Date] ),
    ALL ( Dates )
)
  • Nemes's avatar
    Nemes
    Frequent Visitor
    8 years ago

    That does seem to work! I thought I tried this before, but I think I tried ALL('Dates'[Date]) instead of ALL(Dates). I'm not sure why specifying only the Date column as an argument to ALL doesn't work, considering thre are no date duplicates.

     

    Would you know why I need to specify the ALL() function, unlike all of the other how-to's and guides that I've found on this subject?