Dax Formula not giving correct values.

[Anonymous]

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.

let me know if you need more information

regards 

Manwatha Immanuel

[amitchandak · Accepted solution]

@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]

Hi @amitchandak  your surgestion worked thanks alot.

ive used this formula 

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

[amitchandak]

@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]

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?