Forum Discussion
ALLSELECTED INSIDE OF ALLEXCEPT?
Ok, I think I resolved it.
Because of the Table structure of the Pivot Table, I had to include the First, and Last Name fields, as well:
Total Amount Selected Persons :=
CALCULATE (
SUM ( [Amount] ),
ALLSELECTED ( Payroll_Table[User ID] ),
ALLSELECTED ( Payroll_Table[First Name] ),
ALLSELECTED ( Payroll_Table[Last Name] ),
ALLS ( Payroll_Table[P&L] ),
ALL ( Payroll_Table[Department] ),
ALL ( Payroll_Table[Job Grade] )
)Results are now better.
Your measure doesn't work I'm afraid.
I get this, which is quite wrong
Ok, I think I resolved it.
Because of the Table structure of the Pivot Table, I had to include the First, and Last Name fields, as well:
Total Amount Selected Persons :=
CALCULATE (
SUM ( [Amount] ),
ALLSELECTED ( Payroll_Table[User ID] ),
ALLSELECTED ( Payroll_Table[First Name] ),
ALLSELECTED ( Payroll_Table[Last Name] ),
ALLS ( Payroll_Table[P&L] ),
ALL ( Payroll_Table[Department] ),
ALL ( Payroll_Table[Job Grade] )
)
Results are now better.