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 NoteDate when adding date columns from calendar table to visual, and it should be done by measure.
Thank you
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 🙂
2 Replies
- Fowmy
Super User
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 🙂
