Forum Discussion
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...
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
