topic Re: Modify DAX Formula to Include 2 Conditions in DAX Commands and Tips

Modify DAX Formula to Include 2 Conditions

jmetf150 — Wed, 17 Jan 2024 15:26:27 GMT

Total Orders by Vendor = Var OrdersPerVen='ZPSMGR'[Ven #] Return Countrows( filter( All('ZPSMGR'),OrdersPerVen='ZPSMGR'[Ven #]))

I am making a dashboard for on time delivery metrics. I figured out how to countrows for only a certain ven number to see how many orders were recieved from that vendor. Now I need to add another column with the same code but with an additonal condition/pararmeter (that may be the wrong term) that will show me only rows with that [Ven #] && were "On Time" from the [OTD] column.

Re: Modify DAX Formula to Include 2 Conditions

Anonymous — Thu, 18 Jan 2024 01:43:06 GMT

Hi jmetf150 ,

If I understand correctly, the issue is that you want to modify formula to include multiple conditions.

You can modify the DAX formula to include the additional condition. Please try the following DAX formula and check if can solve your problem:

Total Orders by Vendor On Time = VAR OrdersPerVen = 'ZPSMGR'[Ven #] RETURN COUNTROWS( FILTER( ALL('ZPSMGR'), OrdersPerVen = 'ZPSMGR'[Ven #] && 'ZPSMGR'[OTD] = "On Time" ) )

Looking forward to your reply.

Best Regards,

Wisdom Wu

Re: Modify DAX Formula to Include 2 Conditions

jmetf150 — Mon, 22 Jan 2024 21:52:25 GMT

That worked. Thank you.