Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Microsoft Power BI Community
- Forums
- Get Help with Power BI
- Desktop
- Measures dependent on Slicers

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

ajcde

New Member

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-11-2017
05:39 AM

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.

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

v-sihou-msft

Microsoft

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-12-2017
01:37 AM

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,

3 REPLIES 3

Highlighted
##

PeterGarant

Helper I

Re: Measures dependent on Slicers

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-11-2017
05:54 AM

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

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

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
##

ajcde

New Member

Re: Measures dependent on Slicers

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-11-2017
05:58 AM

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

v-sihou-msft

Microsoft

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-12-2017
01:37 AM

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,

Announcements

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

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

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

Top Solution Authors

User | Count |
---|---|

375 | |

122 | |

95 | |

92 | |

85 |

Top Kudoed Authors

User | Count |
---|---|

527 | |

190 | |

186 | |

149 | |

122 |