Skip to main content
cancel
Showing results for 
Search instead 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

Reply
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.
let me know if you need more information
ManwathaI_1-1618478614962.png

 

regards 

Manwatha Immanuel

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
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

View solution in original post

4 REPLIES 4
amitchandak
Super User
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)

amitchandak
Super User
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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors