How to display values for only Latest ID

[BhavyaM]

I have to show Maximum value and Max-1 value based on ID, 

I dont have date column 

Max column should show values only for Max id and Max-1 rows should show as Blank()

Min column should show values only for Max-1 id and Max rows should show as Blank()

Max =

Var a = CALCULATE(SUM('A'[VALUE]),FILTER('A','A'[ID] = MAX('A'[ID])))

Return

SWITCH(TRUE(),

a=0.00,0.00,

a>0,a,""

)

Min =

Var a = CALCULATE(SUM('A'[VALUE]),FILTER('A','A'[ID] = Min('A'[ID])))

Return

SWITCH(TRUE(),

a=0.00,0.00,

a>0,a,""

)

but i am not getting as expected

Please provide me solution

Thanks in advance

[v-easonf-msft · Accepted solution]

Hi, @BhavyaM 

If there is any other column in your table to identify each row of data?

Based on the information you currently provide, I have modified your original  measure  as below:

Max1 = 
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'A'[ID] ) = MAXX ( ALL ( A ), A[ID] ), SELECTEDVALUE ( A[VALUE] ),
    SELECTEDVALUE ( 'A'[ID] ) = MINX ( ALL ( A ), A[ID] ), BLANK ()
)

Min1 = 
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'A'[ID] ) = MAXX ( ALL ( A ), A[ID] ), BLANK (),
    SELECTEDVALUE ( 'A'[ID] ) = MINX ( ALL ( A ), A[ID] ), SELECTEDVALUE ( A[VALUE] )
)

Please check my sample file for more details.

If it doen't meet your requirement,please let me know.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@BhavyaM , All values are same, How will min and max be different ?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[BhavyaM]

I am considering Latest and Latest-1 ID and calculating it value. 

ID	VALUE	Current ID Value	Previous ID Value
2020121713	1254.39	1254.39	1254.39
2020121713	1254.39	1254.39	1254.39
2020121713	1254.39	1254.39	1254.39
2020121713	1254.39	1254.39	1254.39
2020121713	0.332	0.332	0.332
2020121713	0.332	0.332	0.332
2020121713	0.332	0.332	0.332
2020121713	0.332	0.332	0.332
2020121713	0.332	0.332	0.332
2020121617	0	0	0
2020121617	0	0	0
2020121617	0	0	0
2020121617	0	0	0
2020121617	0	0	0
2020121617	0	0	0
2020121617	0	0	0
2020121617	0	0	0
2020121617	0	0	0
2020121617	0	0	0
2020121617	0	0	0
2020121617	0	0	0
2020121617	0	0	0
2020121617	276.955	276.955	276.955
2020121617	3442.63	3442.63	3442.63
2020121617	258.491	258.491	258.491
2020121617	3442.63	3442.63	3442.63
2020121617	3442.63	3442.63	3442.63
2020121617	3442.63	3442.63	3442.63
2020121617	3442.63	3442.63	3442.63
2020121617	0.916	0.916	0.916
2020121617	0.916	0.916	0.916
2020121617	0.916	0.916	0.916
2020121617	0.916	0.916	0.916
2020121617	0.916	0.916	0.916
2020121617	0	0	0