Forum Discussion
Help with summarize or grouping please.
hello,
i want the sum of a column by grouping.
so i want to SUM 'Attendee Details_3'[KPMG Personnel Indicator] by the 'Attendee Details_3'[Entry Legacy Key].
Please help. Thank you
Hi thx ,
You can try the following Dax:
Calculated columns:
Column = SUMX( FILTER(ALL('Table'),'Table'[Entry Legacy Key]=EARLIER('Table'[Entry Legacy Key])),[ABC Personnel Indicator])Measure:
Measure = SUMX( FILTER(ALL('Table'),'Table'[Entry Legacy Key]=MAX('Table'[Entry Legacy Key])),[ABC Personnel Indicator])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
2 Replies
Did you want that as a separate table, or as a visual?
Create a table visual, add the one field, set it to "Do not summarize". Add the second field, set it to "Sum".
Sopunds too easy. What am I missing?
Hi thx ,
You can try the following Dax:
Calculated columns:
Column = SUMX( FILTER(ALL('Table'),'Table'[Entry Legacy Key]=EARLIER('Table'[Entry Legacy Key])),[ABC Personnel Indicator])Measure:
Measure = SUMX( FILTER(ALL('Table'),'Table'[Entry Legacy Key]=MAX('Table'[Entry Legacy Key])),[ABC Personnel Indicator])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
