DAX different grand totals for calculated measure - mulitple dimensions

[werdinka]

Hi Guys,

 I need to calculate "forecast" basing on last available data for the month ( I need to show it till the end of the year) . I need it to show correct grand totals for two or more dimensions- in this case for category and for product . This is formula I used:

Test2:=CALCULATE((CALCULATE([sumofamount],filter(all('Calendar'),Calendar[Date]=MAX(Table1[Period])))),filter(all('Calendar'),Calendar[Date]<=MAX(Calendar[Date]))) As you see below - I need grand total (and subtotals ) to show sum of shown values (as in row Total I need). 

you can find my example here: https://ufile.io/efav3

I will be grateful for any tip. Thanks in advance

[v-yuta-msft]

Hi werdinka,

The Grand Total result seems right, see screen below, can you clarify more details and logic about your requirement and expected result?

 

Regards,

Jimmy Tao

[werdinka]

Hi, on your screen there is just a sum of amount in grantotal as i see. In the example i shared there is a measure "test2", which calculates a forecast based on last availabe data for month.  and it doesnt show sum of calculated Test2 in grand total, but just a sum of amount.