Forum Discussion

FranRQ's avatar
FranRQ
Frequent Visitor
5 years ago
Solved

Filter by latest revision

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,
Need Help
  • tamdo95's avatar
    tamdo95
    5 years ago

    Hello,

    Here is my solution:

     

    amountLastRevision =

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

RETURN

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

     

     



  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
FranRQ
Frequent Visitor
5 years ago

Thank you for the solution 

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