Help with Custome Column

Try like

Charge type order 1 count =
sumx(summarize(table3, table3[Order_no],"_ch1" ,sumx(table3,If(Table3[Charge Type Code] = "1", 1,0)),"_all",count(Order_no))
		if(_ch1=_all,1,0))
		
Charge type order not 1 count =
sumx(summarize(table3, table3[Order_no],"_ch1" ,sumx(table3,If(Table3[Charge Type Code] = "1", 1,0)),"_all",count(Order_no))
		if(_ch1=_all,0,1))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

Hi GomzeeR , 

I am not clear about your requirement, if you want to get distinct count of order number, I think you could try below measures

Measure = CALCULATE(DISTINCTCOUNT('Table'[Order No.]), 'Table'[Charge Type Code]="1")
Measure2 = CALCULATE(DISTINCTCOUNT('Table'[Order No.]), 'Table'[Charge Type Code]<>"1")

If not, could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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