Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 want to keep certain page-level filters.
Can anyone fix my formula? Thanks in advance
Total Headcount - Fixed = CALCULATE( SUM(Occupancy[Headcount]), Occupancy[BU] IN {"Marketing", "Sales", "Head Office", "Support", "Ops", "IT", "Senior Team"} ) + 0 ALL('Real Estate'[Building]), ALL('Real Estate'[City]), ALL('Real Estate'[Country]), ALL('Real Estate'[Region]))
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |