Filter by latest revision

[FranRQ]

Good morning Community!
I need to create a measure that shows me only the amount of the last revision, associated with each Client Code.

Thank you,

[tamdo95 · Accepted solution]

Hello,

Here is my solution:

amountLastRevision =

VAR lastRevision = CALCULATE ( MAX ( 'Table'[Revision] ) )

RETURN

CALCULATE ( VALUES ( 'Table'[Importe] ), 'Table'[Revision] = lastRevision )

[v-yangliu-msft · Accepted solution]

Hi  @FranRQ ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _1=CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),'Table'[Client Code]=MAX('Table'[Client Code])&&'Table'[Revision]=MAXX(FILTER(ALL('Table'),'Table'[Client Code]=MAX('Table'[Client Code])),'Table'[Revision])))
return
IF(MAX('Table'[Revision])=MAXX(FILTER(ALL('Table'),'Table'[Client Code]=MAX('Table'[Client Code])),'Table'[Revision]),_1,BLANK())

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[FranRQ]

Thank you for the solution v-yangliu-msft for,

Just one more comment. How can I show the resulting total in the table?

[tamdo95 · Accepted solution]

Hello,

Here is my solution:

amountLastRevision =

VAR lastRevision = CALCULATE ( MAX ( 'Table'[Revision] ) )

RETURN

CALCULATE ( VALUES ( 'Table'[Importe] ), 'Table'[Revision] = lastRevision )