Issue with DAX - Returns the same data against every record

[mayurbajaj]

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

Its giving me the same Max Date against every record

Not too sure why?

[mark_endicott · Accepted solution]

@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.