Forum Discussion

GINMED's avatar
GINMED
Helper 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

MahyarTF's avatar
MahyarTF
Memorable Member
4 years ago

Hi,

It should work.

Would you please share sample data and your expectation ?

  • GINMED's avatar
    GINMED
    Helper III
    4 years ago

    MahyarTF 

    my expectation:

    correct payments(kasko_first & kasko_last) per each item, like below

    Now it shows incorrect values for last payment per item, it shows only correct for last one sequence, not for each item

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi GINMED,

      You can try to use the item as the category to filter on the iterator function sumx calculations:

      formula =
VAR FirstPayment =
    MINX ( VALUES ( 'Līgumi_Project'[Item] ), ( 'Līgumi_Project'[Sequence] ) )
VAR LastPayment =
    MAXX ( VALUES ( 'Līgumi_Project'[Item] ), ( '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

      Regards,

      Xiaoxin Sheng

      • GINMED's avatar
        GINMED
        Helper III
        4 years ago

        Anonymous 

        thank you, but that one does not work for me