topic Re: Replace (Blank) with 'Value' - Calculated Column in DAX Commands and Tips

Replace (Blank) with 'Value' - Calculated Column

Anonymous — Tue, 23 Apr 2024 11:16:26 GMT

Hi Team,

I have a calculated column in my table view as below :

Sample= Table[A] & " " & LOOKUPVALUE('Table1'[B],'Table1'[C],Table[A],Blank())

which returns the below

Please advise since I tried using ISBLANK but nothing seems to work

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Tue, 23 Apr 2024 14:23:56 GMT

Try IF( ISBANK( ......) = True, "Value you want when blank", "value you want when not blank i.e. your function")

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Tue, 23 Apr 2024 14:29:59 GMT

Anonymous Thanks but no change. For some reason the blank values remain

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Tue, 23 Apr 2024 14:32:31 GMT

I think the issue is within the lookup, but I'm not experienced enough to resolve it without seeing more data. Hopefully someone will come along and give you more guidance

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Wed, 24 Apr 2024 09:44:59 GMT

Hi Anonymous

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Wed, 24 Apr 2024 12:12:00 GMT

V-V Anonymous Please refer to the attached!

Can the category for both these entries be changes to "New Test"?

Dokumente

Thanks

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 05:58:02 GMT

Hi Anonymous

Can you elaborate on the circumstances under which the value of the “Category New” column changes to “New Test”?

Best Regards,

Jayleny

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 07:43:49 GMT

Anonymous When there is no value or maybe we can say if the value "1005" or "1006" is noticed then I would like to call it "New Test". Thanks

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 07:59:40 GMT

Hi Anonymous

Please try the following Dax:

Measure = IF(SELECTEDVALUE('Actuals'[Category])=BLANK(),"New Test",MAX('Actuals'[Category]))

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 08:40:27 GMT

Anonymous Thank you I see it is close but please refer to the below. The first 3 rows under measure column should show up as "BC"

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 08:53:26 GMT

Hi Anonymous

Consider using the following measure:

Measure = IF(SELECTEDVALUE('Actuals'[Category])=BLANK(),"NA",MAX('Actuals'[Category]))

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 08:58:33 GMT

Hi Anonymous Thanks. Tried same for some reason my side it does not work. Also please note that my actual calculation is a Sample= Table[A] & " " & LOOKUPVALUE('Table1'[B],'Table1'[C],Table[A],Blank())

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 09:03:22 GMT

Hi Anonymous

You're using a calculated column, please use measure to do the calculation.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 09:12:36 GMT

Anonymous Thanks...can you please tell me if this can be shown as a column as my data needs this to be shown as a dimension instead of a measure.

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 09:18:20 GMT

Hi Anonymous

Try the following DAX:

Column = IF([Category]=BLANK(),"NA",[Category])

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 09:23:21 GMT

Anonymous When I try this I again get back to the original issue where only blank is shown and no value is updated. Please advise!

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 09:32:57 GMT

Hi Anonymous

I did the corresponding operation in the PBIX file you provided, please refer to the DAX in it.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Replace (Blank) with 'Value' - Calculated Column

Anonymous — Thu, 25 Apr 2024 09:44:12 GMT

Anonymous Thanks works perfectly fine in the sample file but not in the real scenario..could you please advise why? I see only blanks again unforunately. Would the below be reason?

This is actually the calculated field calculation for Category

LOOKUPVALUE(Table[A] & " " & LOOKUPVALUE('Table1'[B],'Table1'[C],Table[A],Blank()))