Calculation Measure

[pmhoang94]

I have a table with measure:

TodayValSI = CALCULATE(SUM(SalesInOut[Amount])/1000000,FILTER(  
	ALL( SalesInOut[DateID]),   
      [DateID] = [MaxDate]
),SalesInOut[SalesType] = "I", SalesInOut[FreeItem] = FALSE())

Measure MaxDate:

MaxDate = CALCULATE(MAX(SalesInOut[DateID]), ALL(SalesInOut[DateID]))

I create a table with2 columns: ProductLine and TodayValSI.

I create a sclicer DateID to filter my table.

If I not filter, data in my table display not correct.

But if I filter MaxDate (2017/05/31), data in my table display correct.

Why?

Am I missing something?

This is link my report: https://drive.google.com/file/d/0B1L_chy-uFDKMTJGZHJYc3hiM1E/view?usp=sharing

[pmhoang94]

[v-sihou-msft · Accepted solution]

@pmhoang94

Your issue is on your dummy measure [MaxDate].

You limit the context into entire Table so that on grand total level, it will always take the max date in the table which is "2017/5/31"

Just remove the ALL() part, it will return correct result.

Regards,