Forum Discussion

pmhoang94's avatar
pmhoang94
Helper I
9 years ago
Solved

Calculation Measure

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

     

    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,

     

     

2 Replies

    • v-sihou-msft's avatar
      v-sihou-msft
      Microsoft Employee

      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,