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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Nested IF Based on two cummulative conditions

Hello,

 

I have this table:

OrderCriteria 1Criteria 2
1100%BLANK Value
290%BLANK Value
385%25%
4100%100%

 

Now I want to create a Status column that basically follows the assumptions below:

- Criteria 1 threshold = 100%

- Criteria 2 threshold = 0%

- If one the above assumptions doesn't follow the threshold we should mark the line as Rejected

 

Example of my goal:

 

OrderCriteria 1Criteria 2Status
1100%BLANK ValueAccepted
290%BLANK ValueRejected
385%25%Rejected
4100%100%Rejected

 

Can you please help me?

 

I'm trying with this, but no success so far

 

PO Status = 
VAR one_ = [Criteria 1]
VAR two_ = [Criteria 2]
RETURN
IF(ISBLANK(one_) || one_ < 1,IF(two_ > 0,"Rejected","Accepted"))

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Anonymous 
Please try

PO Status =
VAR one_ = [Criteria 1]
VAR two_ = [Criteria 2]
RETURN
    IF ( one_ < 1 || two_ > 0, "Rejected", "Accepted" )

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

So simple and so effective. Many thanks !!

tamerj1
Super User
Super User

Hi @Anonymous 
Please try

PO Status =
VAR one_ = [Criteria 1]
VAR two_ = [Criteria 2]
RETURN
    IF ( one_ < 1 || two_ > 0, "Rejected", "Accepted" )

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.