cancel
Showing results 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

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?

1 ACCEPTED SOLUTION
Helper II

Modified above formula with isblank function.

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

2 REPLIES 2
Helper II

Modified above formula with isblank function.

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

Super User

Hi @SonaSinghA ,

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

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Announcements

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

#### Power BI Monthly Update - February 2024

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

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Top Solution Authors
Top Kudoed Authors