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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi GINMED,

        Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

        How to Get Your Question Answered Quickly  

        Regards,

        Xiaoxin Sheng