DAX Count Only the first occurence of a measure value

[sajal161292]

Hi,

I would like to calculate the first occurence of a measure value...

i.e. i would like to see the value 78 only for the negative Total and should not show the remaining values(77,76,75,74,73,72)  for the negative total.

[Anonymous · Accepted solution]

Hi @sajal161292,

I think you can simply add if statement to check row contents and calculate result.(use new formula to calculate on rows who achieve above conditions)

Sample:

Customize measure=
VAR current_row =
    SELECTEDVALUE ( Table[Column] )
VAR result = 'original calculate formula'
RETURN
    IF (
        current_row = "Total"
            && reuslt < 0,
        'custom formula for get total',
        result
    )

Notice: please use your formula to replace bold part.

Regards,

Xiaoxin Sheng