Forum Discussion
Check for Zero / blank vale in If function DAX
Hi all!
I have a table that shows the YTD availability for each business process service, the elapsed time ( without services) and the peding time to break the SLA agreed (hours depends on each process). Please find attachd the table.
When the used time (impacte time) is 0, I should see the total time available in the table, however i see 00:00
Please check the measure in dax. I am doing something wron as I can not detect the cero value.
As you can see in the previous picture i have "debugged" the result with the column Is blank, to see what is the result of the measure Impact sec. Seems that when the measure [Impact sg] has no value, return blank. Therefore I changed the if statement to IF([Impact sg] == BLANK() but it is not working neither ...
Can any one have a look a give me some advice?
Thanks a lot!!
One thought - when you are getting the process name, is this coming from the correct table in the join? If it's coming from the table that provides [Impact sg], perhaps when that is blank, the table doesn't have any rows for that process. So the entire switch statement would be skipping the row for the process and giving the default case. If it's from the table displaying in the visuals, this should be fine.
2 Replies
One thought - when you are getting the process name, is this coming from the correct table in the join? If it's coming from the table that provides [Impact sg], perhaps when that is blank, the table doesn't have any rows for that process. So the entire switch statement would be skipping the row for the process and giving the default case. If it's from the table displaying in the visuals, this should be fine.
thanks kleigh
that´s it. I was getting the process from the wrong table! now is working. I spent two day struggling with it
thanks again 😀