Forum Discussion

GINMED's avatar
GINMED
Icon for Helper III rankHelper III
4 years ago
Solved

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(ALLSELEC...
Need Help
  • Anonymous's avatar
    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

Anonymous's avatar
Anonymous
Not applicable
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

GINMED's avatar
GINMED
Icon for Helper III rankHelper III
3 years ago

Anonymous Thank you so much, this one works perfectly!!!