cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Dax Formula not giving correct values.

Hi Team

i need help with the below, so basically what im trying to do is i'm calculating SLA Condition using the below script which is a Column

SLA Condition = IF([Total SLA]<=Activities[CCBA Target],1,0)

im assuming why its giving me wrong values is because im comparing a Measure with a column and all it gives me is 1 which is not correct. ive attached pictures of how ths scenarior looks.

regards

Manwatha Immanuel

1 ACCEPTED SOLUTION
Super User

@Anonymous

Try measure like

SLA Condition = IF([Total SLA]<=Sum(Activities[CCBA Target]),1,0)

or

SLA Condition = IF([Total SLA]<=max(Activities[CCBA Target]),1,0)

Make sure you disply this measure with line level data

4 REPLIES 4
Super User

@Anonymous

Try measure like

SLA Condition = IF([Total SLA]<=Sum(Activities[CCBA Target]),1,0)

or

SLA Condition = IF([Total SLA]<=max(Activities[CCBA Target]),1,0)

Make sure you disply this measure with line level data

Anonymous
Not applicable

Hi @amitchandak  your surgestion worked thanks alot.

ive used this formula

SLA Condition = IF([Total SLA]<=Sum(Activities[CCBA Target]),1,0)

Super User

@Anonymous , if one of them is the measure, it will not work. You can not measure in a new column. You have to create a new measure only

Anonymous
Not applicable

Hi @amitchandak  thank you for your response, do you pehaps have simple method i can convert the column i have and make it a measure without changing data in it?