Column Total with All Other not equal.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Hi mtussey 

At the total level, CurrentProd evaluates to true because SELECTEDVALUE('Pseudo Supplier'[PrimarySupplier]) returns blank. As a result, only TopProdSales is returned. There's nothing in the logic that adds AllOtherSales back in. Try

IF (
    NOT ( HASONEVALUE ( 'Pseudo Supplier'[PrimarySupplier] ) ),
    [CY Units]  -- or TopProdSales + AllOtherSales,
    IF (
        CurrentProd <> "All Other",
        TopProdSales,
        AllOtherSales
    )
)

Hi mtussey,

Thanks for reaching out to the Microsoft fabric community forum.

Just following up to your previous conversation with Ashish_Mathur, danextian and lbendlin, I'd like to confirm if you've successfully resolved this issue or if you need further help.

If you have got the solution then kindly share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

I would also take a moment to thank Ashish_Mathur, danextian and lbendlin, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team