Make a measure ignore a slicer selections

[Anonymous]

Hi,

I have a created measure that I need to update so that it ignores one of my page's slicer selections:

Here is my existing measure:

Utilization OV Benchmark =

DIVIDE (

    CALCULATE (

        SUM ( 'Per 1000 Helper'[Claims] ), 'Per 1000 Helper'[FlagOffice] = "Y", 'Per 1000 Helper'[Benchmark Helper] = "BM" ),

    CALCULATE (

        SUM ( MemberMonths[TotalMembers] ), MemberMonths[Benchmark Helper] = "BM" )

             )

* 1000

I want the above measure to ignore a page slicer that is populated with a field from another table:  It is populated with EmployerGroups[GroupName]. 

Here is a photo of it:

Is there a way to update the measure so that it completely ignores my slicer selection?

Thank you,

Andrew

[selimovd · Accepted solution]

Hey @Anonymous ,

yes, you can ignore the slicer with the ALL function. Just add it to the calculate function:

Utilization OV Benchmark =
DIVIDE(
    CALCULATE(
        SUM( 'Per 1000 Helper'[Claims] ),
        'Per 1000 Helper'[FlagOffice] = "Y",
        'Per 1000 Helper'[Benchmark Helper] = "BM",
        ALL( EmployerGroups[GroupName] )
    ),
    CALCULATE(
        SUM( MemberMonths[TotalMembers] ),
        MemberMonths[Benchmark Helper] = "BM",
        ALL( EmployerGroups[GroupName] )
    )
) * 1000

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic