Group classification if one of its components satisfy a condition

[marianamarques]

Hi community,

We currently sell sets which are a combination of multiple components. 

For example a Farm Set (item code 12345) is made of three components: cows (item code 12344), chicken (item code 12343) and pigs (item code 12342).

I would like to have a rule that shows that the Farm Set is out of stock if one of the three components have a stock less than 3 for example.

Does anyone know a formula that could help me to achieve that?

I have a table that looks like this:

SET NAME	SET CODE	COMPONENT CODE	COMPONENT NAME	COMPONENT STOCK
FARM SET	12345	12344	COWS	5500
FARM SET	12345	12343	CHICKEN	1870
FARM SET	12345	12342	PIGS	1251

Thanks!

[v-yuezhe-msft · Accepted solution]

@marianamarques,

Please check the DAX in the PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1Nok1jyeIy6V0Y47bBF

Regards,
Lydia

[marianamarques]

Thanks a lot Lydia! It works!