Forum Discussion
sekinod
Helper II
Helper IIGet Summary by Customer
My Data Table like this Every customer has a unique NoteDate and Amount but several Post Dates. So in the power bi report, I want to get a table visual like below. The amount is group by N...
sekinod
Try the following measure:Amount Measure = SUMX( VALUES(Target[Customer]), CALCULATE(MAX(Target[Amount])) ) ---------------------------OR-------------------------------- Amount Measure = SUMX( SUMMARIZE( Target , Target[Customer] , "_Amount", MAX(Target[Amount] ) ), [_Amount] )________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super Usersekinod
Try the following measure:
Amount Measure =
SUMX(
VALUES(Target[Customer]),
CALCULATE(MAX(Target[Amount]))
)
---------------------------OR--------------------------------
Amount Measure =
SUMX(
SUMMARIZE( Target , Target[Customer] , "_Amount", MAX(Target[Amount] ) ),
[_Amount]
)
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
