Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
adavid999
Helper V
Helper V

show measure result unaffected by slicers

Hello,

I have the following measure and wanted to know what I need to do to replicate the measure and adjust it to show an 'all' figure unaffected by on screen slicer visuals. (this way I can use it to show slicer selections vs an 'all' figure.)

The measure is:

Result = 
VAR denominator =
    CALCULATE (
        SUM (Table1[sub] ),
       Table1[pop] = 1
    )
VAR numerator =
    CALCULATE (
        SUM(Table1[num] ),
        Table1[empnum]<> 0
            && Table1[pop] = 1
    )
RETURN
    numerator/denominator

 Any advice welcome.

Thanks

1 ACCEPTED SOLUTION
rbriga
Impactful Individual
Impactful Individual

You may create a second metric:

Result (All)=
CALCULATE(
[Result],
REMOVEFILTERS(X)
)

 

Where X is a list of on-screen slicers you have in place, for example:

REMOVEFILTERS(Customers[Country],Items[Category])

You can leave it as REMOVEFILTERS(), but it may be an overkill depending on the context, so you better specify the sliced fields.

-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!

View solution in original post

1 REPLY 1
rbriga
Impactful Individual
Impactful Individual

You may create a second metric:

Result (All)=
CALCULATE(
[Result],
REMOVEFILTERS(X)
)

 

Where X is a list of on-screen slicers you have in place, for example:

REMOVEFILTERS(Customers[Country],Items[Category])

You can leave it as REMOVEFILTERS(), but it may be an overkill depending on the context, so you better specify the sliced fields.

-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors