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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
mayurbajaj
New Member

Issue with DAX - Returns the same data against every record

Actual Code:

MaxStartDate =
MAXX (
    ADDCOLUMNS (
        SUMMARIZE (
            'Bill Header',
            'Bill Header'[Site Meter Identifier],
            'Bill Header'[Account Number]
        ),
        "MaxBillStartDate", CALCULATE(MAX('Bill Header'[Bill Start Date]))
    ),
    [MaxBillStartDate]
)
 
Output
mayurbajaj_0-1716444522548.png

Its giving me the same Max Date against every record

Not too sure why?

1 ACCEPTED SOLUTION
mark_endicott
Super User
Super User

@mayurbajaj - you can try this:

 

VAR meter = 
	SELECTEDVALUE( 'Bill Header'[Site Meter Identifier] )
VAR account_num = 
	SELECTEDVALUE( 'Bill Header'[Account Number] )
VAR calc = 
	CALCULATE (
        MAX ( 'Bill Header'[Bill Start Date] ),
        FILTER ( ALL ( 'Bill Header' ), 'Bill Header'[Site Meter Identifier] = meter, 'Bill Header'[Account Number] = account_num )
    )	
RETURN
    calc

 

If this works, please mark it as the solution. 

View solution in original post

1 REPLY 1
mark_endicott
Super User
Super User

@mayurbajaj - you can try this:

 

VAR meter = 
	SELECTEDVALUE( 'Bill Header'[Site Meter Identifier] )
VAR account_num = 
	SELECTEDVALUE( 'Bill Header'[Account Number] )
VAR calc = 
	CALCULATE (
        MAX ( 'Bill Header'[Bill Start Date] ),
        FILTER ( ALL ( 'Bill Header' ), 'Bill Header'[Site Meter Identifier] = meter, 'Bill Header'[Account Number] = account_num )
    )	
RETURN
    calc

 

If this works, please mark it as the solution. 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!