Show the Text values corresponding to Min operations

[Iamnvt]

hi,

I have a table:

Material	Group	Demand
A	AA	4
B	AA	5
C	AA	2
D	BB	5
E	BB	5
F	CC	6

and this is the desired result:

Row Labels	Min Demand	Material Constraint
AA	            2	           C
BB	            5	         D, E
CC	            6	           F
Grand Total	2	

here is the link to the example: https://1drv.ms/x/s!Aps8poidQa5zk5AxITz93mScJMiqkw

thanks

[affan · Accepted solution]

Hi @Iamnvt,

You can create two measures as below

Min Demand = CALCULATE(MIN(Table1[Demand]),ALLEXCEPT(Table1,Table1[Group]))

Material Constraint = CALCULATE(CONCATENATEX(Table1,Table1[Material],","),FILTER(Table1,Table1[Demand]=Table1[Min Demand]))

This is the result I have got 

You can also download the pbix file for your reference.

https://www.dropbox.com/s/yq81t9bhk7iqvni/Show%20the%20Text%20values%20corresponding%20to%20Min%20op...

Please mark this post as an accepted solution if this helped you.

Regards,

Affan

[Iamnvt]

thanks a lot.

[Iamnvt]

thanks a lot.