topic Re: How to show the value "Text", if there no transaction/record present in the data in DAX Commands and Tips

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

Anonymous — Tue, 09 Aug 2022 09:52:23 GMT

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])

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

SpartaBI — Tue, 09 Aug 2022 09:53:00 GMT

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

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

Anonymous — Tue, 09 Aug 2022 10:09:30 GMT

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

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

SpartaBI — Tue, 09 Aug 2022 10:11:45 GMT

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

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

Anonymous — Tue, 09 Aug 2022 10:19:03 GMT

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"))

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

SpartaBI — Tue, 09 Aug 2022 10:22:16 GMT

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

Can you share the file?

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

Anonymous — Tue, 09 Aug 2022 10:24:48 GMT

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

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

SpartaBI — Tue, 09 Aug 2022 10:30:30 GMT

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

Showcase Report – Contoso By SpartaBI

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

Anonymous — Tue, 09 Aug 2022 12:40:37 GMT

still not working, any other DAX code?

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

SpartaBI — Tue, 09 Aug 2022 12:45:18 GMT

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