Forum Discussion
Iamnvt
Continued Contributor
Continued ContributorShow the Text values corresponding to Min operations
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
B...
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.
Please mark this post as an accepted solution if this helped you.
Regards,
Affan
affan
Solution Sage
Solution SageHi 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.
Please mark this post as an accepted solution if this helped you.
Regards,
Affan
IamnvtContinued Contributor
Continued Contributorthanks a lot.