topic Re: Dax Formula not giving correct values. in DAX Commands and Tips

Dax Formula not giving correct values.

Anonymous — Thu, 15 Apr 2021 09:25:43 GMT

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

Re: Dax Formula not giving correct values.

amitchandak — Thu, 15 Apr 2021 10:04:25 GMT

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

Re: Dax Formula not giving correct values.

Anonymous — Thu, 15 Apr 2021 10:11:27 GMT

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?

Re: Dax Formula not giving correct values.

amitchandak — Thu, 15 Apr 2021 10:13:23 GMT

Anonymous

Try measure like

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

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

Make sure you disply this measure with line level data

Re: Dax Formula not giving correct values.

Anonymous — Thu, 15 Apr 2021 13:41:09 GMT

Hi amitchandak your surgestion worked thanks alot.

ive used this formula

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