Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to Solution.
Hello,
Here is my solution:
amountLastRevision =
VAR lastRevision = CALCULATE ( MAX ( 'Table'[Revision] ) )
RETURN
CALCULATE ( VALUES ( 'Table'[Importe] ), 'Table'[Revision] = lastRevision )
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
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
Thank you for the solution v-yangliu-msft for,
Just one more comment. How can I show the resulting total in the table?
Hello,
Here is my solution:
amountLastRevision =
VAR lastRevision = CALCULATE ( MAX ( 'Table'[Revision] ) )
RETURN
CALCULATE ( VALUES ( 'Table'[Importe] ), 'Table'[Revision] = lastRevision )
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |