Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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])
@BalaKiranM maybe it's empty text and not a blank there.
try:
If('Schedule'[DISPATCH_GROUPTIME]) = BLANK(), "D/O",'Schedule'[Adj TimeCount1])
Thanks for your quick response, but it still showing the blank.
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
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"))
I think you just need 1st ro check why is it blank there.
Can you share the file?
There is no transaction/entry for that, that is the reason it shows blank. So, How I can show that as "D/O".
@BalaKiranM try:
If('Schedule'[DISPATCH_GROUPTIME]) = BLANK() || 'Schedule'[Adj TimeCount1] = BLANK(), "D/O",'Schedule'[Adj TimeCount1])
still not working, any other DAX code?
Best if you can share a sample file that shows your issue
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |