Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
jmetf150
Helper I
Helper I

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 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.   

 

 

 

 

 

 
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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

 

That worked.  Thank you.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.