Forum Discussion
Understanding the differences between two time-intelligence expressions relative to Visual
I'm working on some time intliegence analysis. So I reviewed the Italian's article on the subject. Prior to reviewing their article I had managed to write my own expression for YTD. I then applied...
It needs a date context. You can see the total is blank too.
You should be able to supply a context by wrapping your calculate in another one, simulating the outer filter context that you get in a visual
Calculate(
Your calculate
, treatas( {max(dates[date])}, date[date])
)
So my intution was correct, its the lack of date context supplied by the Card that causes the issue.
My understanding was that it is generally bad form to nest Calculates within Calculates?
My intution is that the biggest drawback to sticking with my original measure as compared to the DAX pattern based measure is likely performance, more than anything?