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

SLA MET AND NOT MET:

Hi Team,

Please help me to calculate Dax for  SLA load Met/Not  (window hours is 6 hours for all)

Calculated  Load sla time as below which is working fine but unable to calculate met and not met from it.

LoadSLATime = datediff(MAX('Completeness Data Pipeline Execution Details'[NIFI Start Time]), max('Completeness Data Pipeline Execution Details'[Data Pipeline End]), minute)/60
SLA Load MET = IF('Completeness Data Pipeline Execution Details'[LoadSLATime]<='Table Master'[Data Load Window Hours], TRUE(),FALSE())

Sla load met is not working correctly ,please find the yellow highliter :

Snehaxpathak_1-1649187850547.png

 

 

9 REPLIES 9
v-yanjiang-msft
Community Support
Community Support

Hi @Anonymous ,

Has your problem been solved? If yes, please consider accept it as the solution to help the other members find it more quickly.

If not, simply change the data type of [Data Load Window Hours] to number, because result of the LoadSLATime is a number but not a time.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Whitewater100
Solution Sage
Solution Sage

Hi:

Please find one potential solution. As mentioned earlier it required a little changing of data types. Please see link here. I made up figures but had a few of yours in there. I could have combined the goal column into the final column but thought you might want to see it.

https://drive.google.com/file/d/1DW33FTVMJ0Z5SqAWiBGAFzizPmww91oB/view?usp=sharing 

 

Here is the excel source data link I used  if you want to see the steps. I hope this helps and solves the question.

https://docs.google.com/spreadsheets/d/1uFTqyjUKJZLTvs1-Kbc5cjSEmz-RITy1/edit?usp=sharing&ouid=10785... 

 

Whitewater100_0-1649207800584.png

 

 

Anonymous
Not applicable

Hi,

i am unable to create goal column. Please find the error below:

Snehaxpathak_0-1649225608120.png

Thanks,

 

Hi:

What Tom said looks accurate. 

Can you create the goal as calculated column? Because the goal forumla refers to the first field (NISI..)I would check to make data type Date/Time. 

Whitewater100_0-1649249148107.png

If you want to make a measure you can do:

Goal 2 =
var starttime = SELECTEDVALUE('Completeness Data Pipeline Execution Details'[NIFI Start Time])
var datacompleteness = SELECTEDVALUE('Completeness Data Pipeline Execution Details'[Data Load Window Hours])
var fracofday = DIVIDE(datacompleteness, 24)
return
starttime + fracofday
 
Here is a table on report canvas:
Whitewater100_1-1649249969425.png

 

Hi @Anonymous ,

 

I haven't looked into the file, but it seems like you are trying to create a measure while you are saying to would like to create a column 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Anonymous
Not applicable

Hi Tom,

 

I tried both measure and column but its not working for me.

Anonymous
Not applicable

looks like SLA Met/not Met  Dax logic is incorrect. Please help.

tackytechtom
Super User
Super User

Hi @Anonymous ,

 

How are the tables Completeness Data Pipeline Execution Details' and 'Table Master' connected with each other? Also what is the data type of the Data Load Window Hours column?

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Anonymous
Not applicable

Hi Tom,

 

yes both table are connected. Data type is datetime for window hours.

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