Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

IF statement sort to remove blank values

I currently have a sort function to only include values: "company A" and "All Other" yet my %s are a little off, is there a way to remove blank/null values from this via DAX formula? (as I assume they are causing the issue)

 

Company Supplier Sort = IF([Company_Supplier_Name] = "Company A" || [Company_Supplier_Name] = "Company A",[Company_Supplier_Name], "All Other")

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Can you pls elaborate on the problem you are facing.

     

     

    Also, any specific reason of using this twice in you formula.

     

    Company Supplier Sort = IF([Company_Supplier_Name] = "Company A" || [Company_Supplier_Name] = "Company A",[Company_Supplier_Name], "All Other")

     

     

    Regards,

    HN