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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
SonaSinghA
Helper II
Helper II

DAX measure help

I have created a column like below
Surprise Escalation Score =
IF('Data'[Escalation] = 0,0,
IF('Data'[Escalation] = 1 && 'Data'[Risk reference]= 1,0.5,1))

Surprise Escalations = AVERAGE('Data'[Surprise Escalation Score])

Surprise Escalation Score =
IF([Surprise Escalations] = BLANK(),BLANK(),
IF([Surprise Escalations] = 0,120,
IF([Surprise Escalations] > 0.03, -30,BLANK()
)))
 
Why 0 is treating as blank in first case?
 
Please help
1 ACCEPTED SOLUTION
SonaSinghA
Helper II
Helper II

Modified above formula with isblank function.

 

Escalation Score =
IF( ISBLANK([Escalation]), BLANK(),
IF([Escalation] = 0,120,
IF([Escalation] > 0.03, -30,BLANK()
)))
 
 

View solution in original post

2 REPLIES 2
SonaSinghA
Helper II
Helper II

Modified above formula with isblank function.

 

Escalation Score =
IF( ISBLANK([Escalation]), BLANK(),
IF([Escalation] = 0,120,
IF([Escalation] > 0.03, -30,BLANK()
)))
 
 
MFelix
Super User
Super User

Hi @SonaSinghA ,

 

Check if this blog post can help you.

 

https://www.sqlbi.com/articles/blank-handling-in-dax/


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.