cancel
Showing results for
Did you mean:
Frequent Visitor

## 2nd row value in 1st row

Hi All,

I m fresh to BI, I have a problem with delta calculation from a column.

I have a maeasure to calculate the count for every rank.

Can some one help to calculate the delta from next row score.

 Rank Count Score Delta 1 2416 244 76(=244-168) 2 1870 168 43 3 1826 125 23 4 1667 102 21 5 1609 81 52 6 1080 29 8 7 939 21
1 ACCEPTED SOLUTION
Super User III

@KiranGupta15, you may want to adjust the measurement this way

Delta =
VAR __next_rank = MAX ( 'Table'[Rank] ) + 1
VAR __next_score =
CALCULATE (
[Score],
'Table'[Rank] = __next_rank,
ALL ( 'Table' )
)
RETURN
IF ( NOT ISBLANK ( __next_score ), [Score] - __next_score )

4 REPLIES 4
Community Support

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

Super User III

Hi, @KiranGupta15 , you might try this measure

Delta =
VAR __next_rank = MAX ( 'Table'[Rank] ) + 1
VAR __next_score =
CALCULATE (
MAX ( 'Table'[Score] ),
'Table'[Rank] = __next_rank,
ALL ( 'Table' )
)
RETURN
IF ( NOT ISBLANK ( __next_score ), MAX ( 'Table'[Score] ) - __next_score )
Frequent Visitor

Thanks sir....

My "Score"  is a Measure, not a column in table.

"Column 'Score' in table 'Table' cannot be found or may not be used in this expression."

This is the error message ...:

Super User III

@KiranGupta15, you may want to adjust the measurement this way

Delta =
VAR __next_rank = MAX ( 'Table'[Rank] ) + 1
VAR __next_score =
CALCULATE (
[Score],
'Table'[Rank] = __next_rank,
ALL ( 'Table' )
)
RETURN
IF ( NOT ISBLANK ( __next_score ), [Score] - __next_score )

Announcements