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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
mikemagill
Helper I
Helper I

Calculation Group impact on other measures

I posted about this problem in another post and found a work-around but could really do with understanding this properly.

When I create a calculation group, use that calculation group in a slicer and select a single value, the result of other measures are overwritten even if they are totally unconnected.

 

You can see this yourself by looking at this demo report:

 

https://falconxl.sharepoint.com/:u:/s/PowerBI-CalculationGroups/EeYTt7hnDyJCqwBqrjAHSrEBnMJ9VrJWOBlU... 

 

Can anyone explain what I'm misunderstanding or doing wrong?

 

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

This is expected behaviour. The slicer will apply to all visuals on the page unless you turn it off through Edit Interactions. Calculation items are applied to all measures, and so when you choose one in the slicer it will be applied to the test measure.

You can change which measures the calcultion item affect by putting checks in the calc item code using  functions like SELECTEDMEASURENAME or ISSELECTEDMEASURE.

View solution in original post

4 REPLIES 4
johnt75
Super User
Super User

This is expected behaviour. The slicer will apply to all visuals on the page unless you turn it off through Edit Interactions. Calculation items are applied to all measures, and so when you choose one in the slicer it will be applied to the test measure.

You can change which measures the calcultion item affect by putting checks in the calc item code using  functions like SELECTEDMEASURENAME or ISSELECTEDMEASURE.

Perfect.  That's what I was missing.

I can now limit the scope of my calculated items.  I've used code similar to the following:

Group Min =
    IF(
        ISSELECTEDMEASURE([Placeholder Measure]),
        [Min],
        SELECTEDMEASURE()
    )
adudani
Super User
Super User

hi @mikemagill ,

 

Remove the filter interaction as shown below:

1. select the calc group slicer

2. click on format

3. click on edit interactions

4. click on "None" on the top right of the card.

 

is this the intended result? 

 

if this doesn't resolve the issue. kindly elaborate on the required output

adudani_0-1730477109132.png

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash

Thanks.  The edit interactions option is helpful but Johnt75 has a more complete solution.  The problem with edit interactions is where you have a visual with a header based on a measure but you still want the visual to respond to the slicer.

 

Thanks again, though.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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