Dax formular to replace Blank in complaint report to "Still being processed"

[Anonymous]

Hello Community 

I'm currently working on a complaint report and I'm having problems with a DAX measure where I'm calculating the average time (in days) between a complaint entering our system and closing of the complaint. Currently, when there is no closing date for a complaint my measure shows a BLANK. Instead of showing a BLANK for the measure, I would like it to show "in-process" when the complaint hasn't been closed. A picture of my measure and dataset is shown below:

for reference: Beschwerdevorgänge=complaint process 

                      aufnahme= when the ticket was taken by our service team 

                      schlißung= when the ticket was closed

Any help would be greatly appreciated.

Stay safe and healthy 🙂

[Anonymous]

Thank you so much @nandic it worked out perfectly!! Great advice and very appreciated 

[nandic]

Hi @Anonymous , there is a third parameter in Divide function.
Divide(sumaufnahme, aufgenomenne, "Still processing").
Is this final goal?

Regards,
Nemanja Andic

[Anonymous]

Hi Nandic, thanks so much for your answer but its still giving me a blank when there is no closing date for the complaint. My final goal is for the measure to give me the result " still processing " when there is no closing date for a complaint. Cause the divide function at the end divides a figure by 0 which gives us the blank. So most probably there is an error in the var sumaufnahme cause its not differentiating between the closing dates where there is data and where there is none.Thanks again for the help:)  

[nandic · Accepted solution]

Hi @Anonymous ,
In this case you might use calculated column instead of measure?

Duration = IF(ISBLANK('Table'[EndDate]),"Still processing",DATEDIFF('Table'[StartDate],'Table'[EndDate],DAY)&"")

Note 1: i added "" at the end because only one type of data must be in one column. Either it is text, numeric, date.. can't have both numeric and text values in one column.
Note 2: there is one issue in you formula, second variable doesn't do anything in filter part. It just mentions EndDate, but no conditional statement.

var aufgenomenne = CALCULATE(COUNTROWS('Table'),FILTER('Table',ISBLANK('Table'[EndDate])=TRUE()))

This is example how to get number of rows where end date is blank.

Hope some of this info will be helpful.

Regards,
Nemanja Andic