IF statement sort to remove blank values

[Anonymous]

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

[harshnathani]

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