Forum Discussion

shaunguyver's avatar
shaunguyver
Icon for Helper III rankHelper III
8 years ago
Solved

DAX help

I have the following DAX formula that isn't working.   As you can see, I'm trying to sum a value in 'Headcount' by specifying corresponding values in neighbouring column 'BU'.   However, I also w...
Need Help
Show and Tell
  • DaFloDo's avatar
    DaFloDo
    8 years ago

    hi shaunguyver,

     

    i am not sure, but you could try ALLEXCEPT within the CALCULATE

     

    Total Headcount - Fixed = 
    CALCULATE(
		SUM(Occupancy[Headcount])
		, ALLEXCEPT('Real Estate', 'Real Estate'[Building],'Real Estate'[City], 'Real Estate'[Country],'Real Estate'[Region])
		, Occupancy[BU] IN {"Marketing", "Sales", "Head Office", "Support", "Ops", "IT", "Senior Team"}
) + 0

     

     

    regards 

     

    florian

DaFloDo's avatar
DaFloDo
Icon for Resolver I rankResolver I
8 years ago

hi shaunguyver,

 

i am not sure, but you could try ALLEXCEPT within the CALCULATE

 

Total Headcount - Fixed = 
    CALCULATE(
		SUM(Occupancy[Headcount])
		, ALLEXCEPT('Real Estate', 'Real Estate'[Building],'Real Estate'[City], 'Real Estate'[Country],'Real Estate'[Region])
		, Occupancy[BU] IN {"Marketing", "Sales", "Head Office", "Support", "Ops", "IT", "Senior Team"}
) + 0

 

 

regards 

 

florian