What can I do to ignore my page filter?

[Anonymous]

I have a Measure A = CALCULATE ([First Contact Resolution], Calendar'[RelativeWorkingDayNumber] < -9)

However, I want the measure to ignore a page filter of Calendar'[RelativeWorkingDayNumber] = -1.

What DAX can I use for this please?

[v-angzheng-msft]

Hi, @Anonymous 

This is really puzzling.

What is the formula of [First Contact Resolution] and not sure if something is affected by it

Is there any chance you might share a sample file of dummy data for further discussion?

[v-angzheng-msft]

Hi, @Anonymous 

This is what you want:

MeasureA =
CALCULATE (
    [First Contact Resolution],
    FILTER (
        ALL ( 'Calendar'[RelativeWorkingDayNumber] ),
        'Calendar'[RelativeWorkingDayNumber] < -9
    )
)

 In addition, I think formula provided by @parry2k  can also work.

Best Regards,
Community Support Team _ Zeon Zheng

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

[Anonymous]

Hi all,

Thank you for your suggestions. I tried both but the result still gets filtered by the page filter, which I have been trying to ignore.This is the result with page filer 'Calendar' [RelativeWorkingDayNumber] = -1. This is the filter I am trying to avoid.This is the result without page filter which is the result I want even with page filter

[parry2k]

@Anonymous try this:

A = 
CALCULATE (
     [First Contact Resolution], 
     REMOVEFILTER(Calendar'[RelativeWorkingDayNumber]),
     Calendar'[RelativeWorkingDayNumber] < -9)
)

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡