How to show the value "Text", if there no transaction/record present in the data

[Anonymous]

Experts, I have one issue to show the some customized text(D/O) if there no transaction/Entry for the specific record. I have attached ths snapshot for your reference and also DAX which I written. In the below snapshot, I need to show the "D/O" and I written the same in DAX but shows for others but still blank is displaying as per snapshot.

Adj TimeCount col = If(ISBLANK('Schedule'[DISPATCH_GROUPTIME]), "D/O",'Schedule'[Adj TimeCount1])

[SpartaBI]

@Anonymous  maybe it's empty text and not a blank there.
try: 
If('Schedule'[DISPATCH_GROUPTIME]) = BLANK(), "D/O",'Schedule'[Adj TimeCount1])

Showcase Report – Contoso By SpartaBI



      

[Anonymous]

Thanks for your quick response, but it still showing the blank.

[SpartaBI]

btw you are checking one thing for blank and returning another thing. 
So I guess 'Schedule'[DISPATCH_GROUPTIME]) is not blank at that point but maybe 'Schedule'[Adj TimeCount1] is and you just get it's result which is blank

[Anonymous]

In that case, Should I modify this as well?

Adj TimeCount1 = if(distinctcount('Schedule'[Adj Time])=1 ,FORMAT( sum('Schedule'[Adj Time]),"HH:MM AM/PM"))

[SpartaBI]

I think you just need 1st ro check why is it blank there.

Can you share the file?

[Anonymous]

There is no transaction/entry for that, that is the reason it shows blank. So, How I can show that as "D/O".

[SpartaBI]

@Anonymous try:
If('Schedule'[DISPATCH_GROUPTIME]) = BLANK() || 'Schedule'[Adj TimeCount1] = BLANK(), "D/O",'Schedule'[Adj TimeCount1])

Showcase Report – Contoso By SpartaBI



      

[Anonymous]

still not working, any other DAX code?

[SpartaBI]

Best if you can share a sample file that shows your issue