Tuesday, April 24, 2012 1:07 AMI have the following measure:
=CALCULATE(SUM('Internet Sales'[Sales Amount]),DATESINPERIOD('Date'[Date],LASTDATE('Date'[Date]),-q,DAY))/q
Where “q” would be the number of days inputted by the user. The problem is I am not getting any grand total as a default. The measure executes fine when put in date hierarchy and with other dimensions. However, it does not show a GRAND TOTAL by default. It needs a dimension to show grand total. Alone it is meaningless. I want to show a grand total by default. How can I achieve this. Any help is appreciated.
Words offer the means to meaning, and for those who will listen, the enunciation of truth - V for Vendetta.
Tuesday, April 24, 2012 6:11 AM
the reason could be, that your Date-Table has values till e.g. 2015 and you only have facts till 2012
by using LASTDATE() on your Date-Table you will get back 31st Dec 2015 for GRAND TOTAL where you do not have any facts and therefore the SUM is (blank)
you may use LASTDATE('Internet Sales'[<DateColumn>]) instead
- www.pmOne.com -
- Marked As Answer by Challen FuModerator Wednesday, May 02, 2012 8:39 AM