topic Using Remove Filter function in measure not working in DAX Commands and Tips

Using Remove Filter function in measure not working

Karma777 — Tue, 14 Feb 2023 08:50:16 GMT

Hi,

I have a simple visual like below which is a simple bar chart of "Demand" vs "Date-time"

The Demand is a measure calculated as :

Demand Rap = (CALCULATE(sum(Facts[Assignment Committed Work])+sum(Facts[Assignment Proposed Work]), filter(Projects, Projects[Division Priority Project Name] <> BLANK())))/168

There are many page level filters on the report as below.

Now my requirement is, I would like to modify my measure so that selection of "Resource Is Active" filter doesn't impact the calculation ( since there are other visuals on the page which need this filter ). I tried modifying the measure using 'REMOVEFILTER' function but its not working as expected.

Demand Rap exc resoureceIsActive = (CALCULATE(sum(Facts[Assignment Committed Work])+sum(Facts[Assignment Proposed Work]),REMOVEFILTERS(Resources[ResourceIsActive]), filter(Projects, Projects[Division Priority Project Name] <> BLANK())))/168

Please help me in understanding what am I missing here and what should be the correct way to do this.
Thansk you!

Re: Using Remove Filter function in measure not working

Anonymous — Wed, 15 Feb 2023 09:02:15 GMT

Hi Karma777 ,

Here I create a sample file to have a test.

Facts:

Projects:

Project:

Relationship:

I suggest you to create [Demand Rap exc resoureceIsActive] measure based on [Demand Rap] measure.

Demand Rap exc resoureceIsActive = CALCULATE([Demand Rap],REMOVEFILTERS(Resources[ResourceIsActive]))

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Using Remove Filter function in measure not working

Karma777 — Thu, 16 Feb 2023 06:45:09 GMT

Hi Anonymous , Thank you for taking your time to answer. I tried doing this but it still is giving the same result.
Also could you please help me understand how is the data being calculated in the example you showed. Since the report is filtered to resourcetype in (2,20), project p3 value should be ignored. Similarly p4 should be ignored as Division Priority Project Name filed is empty. So I assume the final chart should show only 2 projects- p1 & p2 with the values 3 & 5. Could you please explain how we are getting 5 & 8 in the chart?