Measure for showing lowest cost/week this is in

[TotunG]

Hi all,

I have the following data table:

Group	Code	Stock	Cost	Date
A	REJI3	Apple	21401	07/01/22
A	FDJDA2	Banana	500	07/01/22
B	EFAF3	Shoes	42594	14/01/22
B	DSKOAJ	T-Shirt	224	14/01/22
B	DSJSIS	Trouser	24121	14/01/22
A	REJI3	Apple	53151	14/01/22
A	FDJDA2	Banana	200	14/01/22
C	SDAIDJA	Beer	4214	14/01/22
C	DSLA2	Wine	886	21/03/22
C	DSJIJIJ5	Rum	454	21/03/22
D	SOOO2	Dog	5332	08/06/22

I basically want a measure that would show me the lowest cost by group of product (A, B, C, D etc.), (maybe with the option of drilling down further into the actual stock too). This would then show the corresponding date where the SUM of Cost 'By Group' is lowest.

For a small example the below would return for Group A as the SUM Cost (21401+500) < (53151+200) making 07/01/22 the Date where Cost is lowest.

Group	Code	Stock	Cost	Date
A	REJI3	Apple	21401	07/01/22
A	FDJDA2	Banana	500	07/01/22

[v-jialluo-msft · Accepted solution]

Hi  @TotunG ,

Please follow these steps:
(1) Create a new measure

SUM = CALCULATE(SUM('Table'[Cost]),ALLEXCEPT('Table','Table'[Group],'Table'[Date]))

(2)Apply filtering

(3)Final output

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.