Total % not Showing Correctly

[rajasekaro]

 

Hi Team,

but if i select one or more supplier the spend  total 100 % not showing 

DIVIDE(

    SUM(PO_Detail[amount]),

    CALCULATE(

        SUM(PO_Detail[amount]),FILTER(Supplier,

        ALL(Supplier[NAME])

    )

)

)

[MasonMA]

Hello @rajasekaro 

Your formula 'ALL' removes all filters from the Supplier[NAME] column, which means it will always show the percentage against the grand total, regardless of selections.

Try ALLSELECTED Instead of ALL as this respect your selections while removing filters.

DIVIDE(
SUM(PO_Detail[amount]),
CALCULATE(
SUM(PO_Detail[amount]),
ALLSELECTED(Supplier[NAME])
)
)

Hope this helps:) 

[alish_b · Accepted solution]

Hi @rajasekaro , 

Please try the following in the measure calculation; 

DIVIDE(
    SUM(PO_Detail[amount]),
    CALCULATE(
        SUM(PO_Detail[amount]),
        ALLSELECTED(Supplier[NAME])
    )
)

Basically, ALL() ignores all filters (coming from slicers as well) while ALLSELECTED() ignores other filters but respects user selections/slicers. 

Hope it helps!