Forum Discussion
Solved
CALCULATE DOES NOT FILTER AS INTENDED
Good day all, I am new to PB and I am having problems in obtaining a value that is the difference between demand and capacity for a given region. The goal is to create a measure that gives the diffe...
Hi,
You can use ALL to remove only the location: ALL( [<table> | <column>[, <column>[, <column>[,…]]]] )
[Sales all locations] = CALCULATE(SUM('Master Capacity'[weekly capacity]), ALL('Master Capacity'[location]))
Hi ValtteriN, Thank you for your answer. But if I use ALL, is it not removing all the externals filters applied? I would like to remove only the external filter "Location" (Location slicer) and then set in the formula the region I want, but keep the other external filters applied. Do you think is any way to do it?
ValtteriN
Community Champion
Community ChampionHi,
You can use ALL to remove only the location: ALL( [<table> | <column>[, <column>[, <column>[,…]]]] )
[Sales all locations] = CALCULATE(SUM('Master Capacity'[weekly capacity]), ALL('Master Capacity'[location]))