Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
pmhoang94
Helper I
Helper I

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

 

 

1 ACCEPTED SOLUTION

@pmhoang94

 

Your issue is on your dummy measure [MaxDate].

 

Capture.PNG

 

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.

 

22.PNG

 

Regards,

 

 

View solution in original post

2 REPLIES 2
pmhoang94
Helper I
Helper I

Capture11.PNG

Capture12.PNG

@pmhoang94

 

Your issue is on your dummy measure [MaxDate].

 

Capture.PNG

 

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.

 

22.PNG

 

Regards,

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.