Correct values per item

Hi, I'm using that one measure for getting correct values for first and last payment, but that one does not work for each item.

How can I filter for each item ?

var FirstPayment = MINX(ALLSELECTED('Līgumi_Project'), ('Līgumi_Project'[Sequence]))

var LastPayment = MAXX(ALLSELECTED('Līgumi_Project'), ('Līgumi_Project'[Sequence]))

var CurrentSequence = SELECTEDVALUE('Līgumi_Project'[Sequence])

var CurrentPayment = SELECTEDVALUE('Līgumi_IFRS'[KASKO, EUR])

var result =

SWITCH(

CurrentSequence,

FirstPayment, CALC_NOMAS_MAKS[KASKO_FIRST],

LastPayment, CALC_NOMAS_MAKS[KASKO_LAST],

CurrentPayment

)

return result

Need Help

Anonymous

3 years ago

HI GINMED,

You can try to use the following measure formula if it helps:

KASKO_total = 
VAR firstP =
    CALCULATE (
        MIN ( 'Project'[Sequence] ),
        ALLSELECTED ( 'Project' ),
        VALUES ( 'Project'[PL Nr.] )
    )
VAR lastP =
    CALCULATE (
        MAX ( 'Project'[Sequence] ),
        ALLSELECTED ( 'Project' ),
        VALUES ( 'Project'[PL Nr.] )
    )
VAR CurrentSeq =
    SELECTEDVALUE ( 'Project'[Sequence] )
VAR CurrentP =
    SELECTEDVALUE ( 'Project'[KASKO] )
RETURN
    SWITCH (
        CurrentSeq,
        firstP, 'Calculation'[kasko_first],
        lastP, 'Calculation'[kasko_last],
        CurrentP
    )

Regards,

Xiaoxin Sheng