Need Dax formula for calculating pallets for each product line

[Ice1341]

I have a report built with cases for each item/product line, but in order to get pallet quantity, I need to divide by 40 for JUICE category and 80 for frozen ice. Here's the sample, pallet quantity is incorrect.

Year	Month	billToCustomerNumber	description	GrSalesOrderAmt	Net amount	Pallets	quantity	Prod Line
2022	January	REPIR	STR0298 Strawberry FJ 90pk MC-90 cups/ 4oz ea	4320	4104	2	160	JUICE
2022	January	STAR	CHI0458 Cherrymoji FJ 90pk MC-90 cups/ 4oz ea	30844	30844	11	880	JUICE
2022	January	STAR	MAN0090 Mango FJ 90pk MC-90 cups/ 4oz ea	1080	1080	0.5	40	JUICE
2022	January	STAR	STR0298 Strawberry FJ 90pk MC-90 cups/ 4oz ea	2160	2160	1	80	JUICE
2022	January	STAR	WAT0182 Watermelon FJ 90pk MC-90 cups/ 4oz ea	1080	1080	0.5	40	JUICE
2022	January	GOR0001	MAN0020	1510	1510	0.5	40	FrozenIce

[YukiK]

Could you create a calculated column with your conditions?

[AbbasG · Accepted solution]

@Ice1341 Hi, here is my possible solution. Hope it helps.

Steps:

1. I have created a conditional column based on the product line.

IF JUICE then  40 else by 80 (So that it give me the right number to divide by qty)

2. Then I simply used the divide function to create a calculated column to get the pallets count.

In case you need to refer to the pbix file, here it is