Forum Discussion
SUM column based on distinct ID
Hi all! I cant seem to figure out the following (which looks very straightforward) I have a dataset which shows how much meter a category has in a store. The data set has rows for each artic...
Hi Anonymous ,
You can try this measure:
meters per store = VAR t = SUMMARIZE ( 'Table', 'Table'[Store ID], 'Table'[Category], 'Table'[Length of Category (in meters)] ) RETURN SUMX ( t, [Length of Category (in meters)] )
ERD
Community Champion
Community ChampionHi Anonymous ,
You can try this measure:
meters per store =
VAR t = SUMMARIZE ( 'Table', 'Table'[Store ID], 'Table'[Category], 'Table'[Length of Category (in meters)] )
RETURN
SUMX ( t, [Length of Category (in meters)] )Worked like a charm!
Thanks for the time and help! 🙂