Forum Discussion
Summarize but only first value
I'm trying to summarize some data, but only want to keep the first instance of one of the categories. Data example 'Shops' here: Product Shop type Shop category Bread rolls Superma...
Depending on why you need to summarize, you might not need to use a calculation for it:
If you do need to create a summary, you can consider using something like
Summarized = SUMMARIZE('Table', 'Table'[Product], "First Category", CALCULATE(MIN('Table'[Shop category]))Just a note: the MIN takes the first product alphabetically. If you have some index in your raw data, it's best that you use that in the calculation.