how to make 3 columns added in dax with filter

krishna_murthy — Mon, 29 Sep 2025 16:58:56 GMT

hi Team,

Requesting please check below concern and do the needful.

i have a Event_type fileld in that many classification but i need to add 3 columns to caclualte cont of orders

Order quantity = event_type(OUTWARD_ORDER_CANCEL) + event_type( OUTWARD_ORDER_COMPLETE) + event_type( OUTWARD_ORDER_SHIPMENT_DISPATCH)

is that possible make one dax expression ???? finaly i need all 3 columns should be added and show total orders

Below DAX i have used but getting wrong count values , please fix it is possible

Order quantity =

CALCULATE(

COUNTROWS(order_items),

FILTER(

order_items,

RELATED(outward_orders[event_type]) <> "OUTWARD_ORDER_CANCEL" &&

RELATED(outward_orders[event_type]) <> "OUTWARD_ORDER_COMPLETE" &&

RELATED(outward_orders[event_type]) <> "OUTWARD_ORDER_SHIPMENT_DISPATCH "

))

Re: how to make 3 columns added in dax with filter

MFelix — Mon, 29 Sep 2025 17:37:14 GMT

HI krishna_murthy ,

Try the following code:

Order quantity = CALCULATE( COUNTROWS(order_items), FILTER( order_items, NOT( outward_orders[event_type] in {"OUTWARD_ORDER_CANCEL", "OUTWARD_ORDER_COMPLETE" , "OUTWARD_ORDER_SHIPMENT_DISPATCH " }) ) )

Since you are using the && (and) syntax the values need to be the same I assume that each of your values have only one value so if you add them in a list you can get those rows, since you want to have the different values you need to use the NOT syntax. Since there is a relationship between both tables theres is no need to do the RELATED option

topic Re: how to make 3 columns added in dax with filter in DAX Commands and Tips

how to make 3 columns added in dax with filter

Re: how to make 3 columns added in dax with filter