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(Supplier,
        ALL(Supplier[NAME])
    )
)
)

 

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!

2 Replies

  • alish_b's avatar
    alish_b
    Icon for Super User rankSuper User
    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:)