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

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

    • GINMED's avatar
      GINMED
      Helper III
      3 years ago

      Anonymous  there is my sample data

      • 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