SUMX till amount of value

[apamix]

Hello All, 

I have below pivot table : 

Weeks	Orders	Boxes	Recommended boxes	Create Hours	Packing Hours
1
Monday	450	511	350	17	15
Tuesday	235	314	350	11	10
Wednesday	260	343	350	12	10
Thursday	197	243	350	8	8
Friday	180	234	350	8	7

To create column "Boxes" I have been used below measurement : 

Sum-Boxes:=SUMX ( FILTER ( Range, Range[Rep] = "Outgoing" ), Range[Lines] )

And to calculated "Create Hours" I have been used below measurement : 

Outgoing Boxes:=ROUNDUP(SUM(Range[Boxes CycleTime])/3600,0)

I would like to add column called "Recommended Boxes" which will present a static value of 350 boxes and to create a measurement which will  calculdated the "Create Hours" only for those 350 lines. 

Thanks in avance for shared ideas and details.  

[lbendlin · Accepted solution]

your sample data does not match your formulas. Please provide sanitized sample data that fully covers your issue. 

Please show the expected outcome based on the sample data you provided. 

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[v-zhangti]

Hi, @apamix 

Can you provide more sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

Best Regards,

Community Support Team _Charlotte

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