Forum Discussion

mtussey's avatar
mtussey
New Member
1 year ago
Solved

Column Total with All Other not equal.

Hello All, Please see I set a calculation to calculate the Top 8, but the one total isn't adding the "all other" (144K).   Here is my measure via help on YouTube: Top Category Units = V...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

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