Forum Discussion

rajasekaro's avatar
rajasekaro
Icon for Helper III rankHelper III
1 year ago
Solved

Total % not Showing Correctly

  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(Su...
Need Help
Tips and Tricks
Tutorial Requests
  • alish_b's avatar
    alish_b
    1 year ago

    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!

MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
1 year ago

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