locked
Grand Total Blank RRS feed

  • Question

  • I 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 1:07 AM

Answers

  • 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

    hth,
    gerhard


    - www.pmOne.com -

    • Marked as answer by Challen Fu Wednesday, May 2, 2012 8:39 AM
    Tuesday, April 24, 2012 6:11 AM
    Answerer