Correct values per item

[GINMED]

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

[MahyarTF]

Hi,

It should work.

Would you please share sample data and your expectation ?

[GINMED]

@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

[v-shex-msft]

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]

@v-shex-msft 

thank you, but that one does not work for me

[v-shex-msft]

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]

@v-shex-msft  there is my sample data

[v-shex-msft · Accepted solution]

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]

@v-shex-msft Thank you so much, this one works perfectly!!!

[GINMED]

@MahyarTF