Forum Discussion

jmetf150's avatar
jmetf150
Helper I
2 years ago
Solved

Modify DAX Formula to Include 2 Conditions

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 metric...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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