ALLSELECTED and ALLEXCEPT Together?

[cebd_31]

Hello Community,

I wanted to see if its possible to create a Calculation that allows me to do the following:

When filtering By Name in a Slicer, I want the percentage to be shown respective to the Name of the Person Selected on the Slicer and be a Percentage calculated by Individual, not a Percentage of total:

Without filtering in the slicer I am getting:

When Filtering I am getting a the percentage of the TOTAL amount that it represents:

Instead I would like it to be the Percentage of the Orders by Name.

I have the below calculation:

% PD = DIVIDE(COUNT(Table2[Open Purchases Days Past Statistical Ship Date]),CALCULATE(COUNT(Table2[Open Purchases Days Past Statistical Ship Date]),ALLEXCEPT(Table2,Table2[Refresh_TimeStamp].[Day])))

Any help will be appreciated.

[DavisBI · Accepted solution]

Hi, @cebd_31 ,

Based on the information you provide, you just need to add the "Name" to AllExcept()

% PD = DIVIDE(COUNT(Table2[Open Purchases Days Past Statistical Ship Date]),CALCULATE(COUNT(Table2[Open Purchases Days Past Statistical Ship Date]),ALLEXCEPT(Table2,Table2[Refresh_TimeStamp].[Day],<name>)))

Mark this post as solution if this helps, thanks!