Forum Discussion

cebd_31's avatar
cebd_31
Regular Visitor
5 years ago
Solved

ALLSELECTED and ALLEXCEPT Together?

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.
Need Help
  • DavisBI's avatar
    DavisBI
    5 years ago

    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!

1 Reply

  • DavisBI's avatar
    DavisBI
    Icon for Solution Specialist rankSolution Specialist
    5 years ago

    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!