cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Measures dependent on Slicers

Is it possible for me to use multiple slicers on a page but only have my measure calculated based on a specific slicer. I want to calculate multiple measures, but each one will be based on a separate slicer on the same page.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Measures dependent on Slicers

@ajcde

 

You can create a measure with multiple other measures. But, you can't use slicer for each involved measure to make different filter context together in this "complex" measure, unless you fix the context in formula for each measure.

 

For example, you create measures like below:

 

Measure A =SUM(Table[Column1])

 

Measure B =SUM(Table[Column2])

 

Measure C =SUM(Table[Column3])

 

Measure Complex = [Measure A] + [Measure B] + [Measure C]

 

Then you may have Silcer A for Measure A, Slicer B for Measure B, and Slicer C for Measure C, and you have edit the interactions to avoid them affecting each other. When you make selection in Slicer A, B and C, those selections will not be taken to Measure Complex, unless you specify filter context for each of them in formula like:

 

Measure Complex =
CALCULATE ( [Measure A], FILTER ( Table, Table[Column] = "XXX" ) )
    + CALCULATE ( [Measure B], FILTER ( Table, Table[Column] = "XXX" ) )
    + CALCULATE ( [Measure C], FILTER ( Table, Table[Column] = "XXX" ) )

 

Regards,

 

 

View solution in original post

3 REPLIES 3
Highlighted
Helper I
Helper I

Re: Measures dependent on Slicers

Yes you can. If you click on the slicer, then you can edit what it interacts with.

image.png

 

After you press that you will be able to see the following:

image.png

 

So here you can choose if the slicer that you have selected should interact with a graph or whatever you have added.

 

Kind regards

Peter

Highlighted
New Member

Re: Measures dependent on Slicers

Right and I have done that for the visualization portion but I want to use the measure again to create a more complex measure that uses multiple measures I previously created. Each measure will be dependent on a different slicer and once I put it into a new calculation it is again being filtered by multiple slicers which I am hoping to avoid.

Highlighted
Microsoft
Microsoft

Re: Measures dependent on Slicers

@ajcde

 

You can create a measure with multiple other measures. But, you can't use slicer for each involved measure to make different filter context together in this "complex" measure, unless you fix the context in formula for each measure.

 

For example, you create measures like below:

 

Measure A =SUM(Table[Column1])

 

Measure B =SUM(Table[Column2])

 

Measure C =SUM(Table[Column3])

 

Measure Complex = [Measure A] + [Measure B] + [Measure C]

 

Then you may have Silcer A for Measure A, Slicer B for Measure B, and Slicer C for Measure C, and you have edit the interactions to avoid them affecting each other. When you make selection in Slicer A, B and C, those selections will not be taken to Measure Complex, unless you specify filter context for each of them in formula like:

 

Measure Complex =
CALCULATE ( [Measure A], FILTER ( Table, Table[Column] = "XXX" ) )
    + CALCULATE ( [Measure B], FILTER ( Table, Table[Column] = "XXX" ) )
    + CALCULATE ( [Measure C], FILTER ( Table, Table[Column] = "XXX" ) )

 

Regards,

 

 

View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors