Replace blank fields with "Uninformed"

[ZachUnger]

Hi Team

Hoping someone can help, I'm trying to place "UNinformed in the blank columns for Inherent risk and have tried the below but still get a blank result. I have used the below before and has worked but for some reason, this one is not. 

Inherent risk of compliance 23 = IF( ISBLANK(D_ACC_Inspections[InspectionStatus]) || (D_ACC_Inspections[InspectionStatus]) = "", "Uninformed", (D_ACC_Inspections[InspectionStatus]))

I've also tried the below and it still leaves it blank. 

Any help is appreciated. 

Cheers 

Zach

[v-ssriganesh]

Hi @ZachUnger,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[ZachUnger]

Unfortunately, none of these solutions worked, and I'm looking into the data as there may be an issue there. Appreciate the support. 

[v-ssriganesh]

Hi @ZachUnger,

We appreciate your efforts and thank you for sharing the update on the issue. If the issue has been resolved, kindly share the insights, as this will assist other community members in resolving similar issues more efficiently.

Thankyou.

[v-ssriganesh]

Hi @ZachUnger,
Awe haven’t heard back from you in a long while, we’re closing this thread. For any further discussions or questions, please start a new post in the Microsoft Fabric Community Forum — we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

[v-ssriganesh]

Hi @ZachUnger,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-ssriganesh]

Hi @ZachUnger,
Thank you for reaching out to the Microsoft Fabric Forum Community.

I have reproduced the scenario using sample data and was able to achieve the expected output by replacing blank fields in the Inherent risk of compliance column with "Uninformed."

To resolve this, I created a new calculated column named Inherent risk of compliance (Fixed) using the following DAX formula:

Inherent risk of compliance (Fixed) = IF(

    ISBLANK(D_ACC_Inspections[Inherent risk of compliance]) || TRIM(D_ACC_Inspections[Inherent risk of compliance]) = "",

    "Uninformed",

    D_ACC_Inspections[Inherent risk of compliance]

)

This formula checks for blank cells in the Inherent risk of compliance column (including cells with spaces using TRIM()) and replaces them with "Uninformed," while retaining the original values for non-blank cells.

I’ve attached a screenshot of the output below for your reference, which shows the original Inherent risk of compliance column alongside the new Inherent risk of compliance (Fixed) column with the blanks replaced. I’ve also attached the .pbix file containing the sample data and the solution for you to review.

Thank you, @pankajnamekar25 & @danextian for sharing your valuable insights.

If this is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[danextian]

Hi @ZachUnger 

In the query editor, what do the values for those blank spaces show? Are they a null or a blank space? If null put null in the value field.

[pankajnamekar25]

Hey ,

Possible to drop pbix with sample data/Dummy data

[pankajnamekar25]

Hi 

You have to create calulcated column for this use below dax

Inherent risk of compliance 23 =
IF(
TRIM(D_ACC_Inspections[InspectionStatus]) = "" || ISBLANK(D_ACC_Inspections[InspectionStatus]),
"Uninformed",
D_ACC_Inspections[InspectionStatus]
)

make sure this column you will use in table , if you need for other column same logic create that columun using same dax by ref revelvant feild.

if solution work for you kindly accept it

Thank You

Pankaj

[ZachUnger]

Hi Unfortunately that gives me the same result

[pankajnamekar25]

else try this 

Inherent risk of compliance 23 =
VAR Status = TRIM(D_ACC_Inspections[InspectionStatus])
RETURN
IF(
Status = "" || ISBLANK(D_ACC_Inspections[InspectionStatus]),
"Uninformed",
Status
)

[ZachUnger]

Now I get this error,

The syntax for 'Status' is incorrect. (DAX(VAR Status = TRIM(D_ACC_Inspections[InspectionStatus])RETURNIF(Status = "" || ISBLANK(D_ACC_Inspections[InspectionStatus]),"Uninformed",Status))).

I cannot share as won't let me upload .pbix

[pankajnamekar25]

Inherent risk of compliance 23 =
VAR Status = TRIM(D_ACC_Inspections[InspectionStatus])
RETURN
IF(
Status = "" || Status= Blank()
"Uninformed",
Status
)

[pankajnamekar25]

have you tried this one

[ZachUnger]

Yes. Didn't like the status option. 

Error message = The syntax for 'status' is incorrect. (DAX(VAR status = TRIM(D_ACC_Inspections[InspectionStatus])RETURNIF(Status = "" || ISBLANK(Status),"Uninformed",Status))).

[ZachUnger]

Error message = The syntax for 'status' is incorrect. (DAX(VAR status = TRIM(D_ACC_Inspections[InspectionStatus])RETURNIF(Status = "" || ISBLANK(Status),"Uninformed",Status))).

[pankajnamekar25]

Output =SWITCH(
TRUE(),
TRIM(D_ACC_Inspections[InspectionStatus]) = "" || ISBLANK(D_ACC_Inspections[InspectionStatus]), "Uninformed",
D_ACC_Inspections[InspectionStatus]
)

[ZachUnger]

No, appreciate your help but still nothing pulling through, I'll check in with our IT to see if the field is actually containing something I'm missing. 

[pankajnamekar25]

This working fine with same senario,

You can use Power Query to replace null as well