Calculation Group Slicer is overriding other measures

[mikemagill]

I have a Calculation Group of 22 measures.  The user can select which measures are shown in a Matrix Visual via a dropdown slicer.

To demonstrate my problem, I have the following measure in a card visual 

TestStatic = "Test"

When multiple items are selected from the Calculation Group slicer, the card visual shows 'Test'.  When a single item is selected, the card visual shows the result of the selected Calculation Group item.

I cannot work out why the calculation group is overriding other unconnected measures.   I have already tried loads of combinations of ALL, REMOVEFILTERS etc.

Help!

[mikemagill]

Thanks. I can't pretend that I particularly understand that page.  I did check the precedence level, which is currently set to two, and experimented with values of 1 and 0 but it had no impact.  It is possible that while developing this report I originally had a second calculation group, which was later deleted.  Could that be causing the issue?

Seeing as my TestStatic measure should not be impacted by anything else, I can't see what is going wrong.

[SamWiseOwl]

Hmm are the measures you are passing out inter linked?

CalculationGroup Sales -> Sales This Year -> Sales this month only

If they aren't you could use Field Parameters to achieve the same result:
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

[mikemagill]

I've just created a very simple report and recreated the problem so it's not anything complicated about my original report.

I can't seem to attach a .pbix file.  All I did was:

• import a single-column table with values 1 to 50
• create two measures to find the max and min values in the table
• create a calculation group with these two measures
• create a matrix visual with the calculation group as rows and one of the measures as values
• add a slicer to the page for the calculation group
• add my TestStatic measure to a card

You'll see the behaviour for yourself when you select a single value from the slicer

[SamWiseOwl · Accepted solution]

It isn't a solution really but could you prevent the slicer affecting the title card by turning off its interactions.
In theory it should make no difference if the title measure and the slicer measures are unrelated but if it does work it will tell you something ...

[mikemagill]

Great shout! That works for my card visual but I'm also using a measure in one of my visual headers.  I can't mess with the interactions otherwise it'll affect the whole visual.

I may have to use text box instead for my visual header.

I'll mark this as a solution but it feels like there should be another way.

Thanks for your help.

[SamWiseOwl]

Boo you do have to exclude them, I was hoping there was a setting but no!

Learn methods to exclude measures in calculation groups with DAX functions and Field Parameters - Yo...

Field Parameters vs Calculation Groups - which one to use in Power BI for a scalable solution - YouT...

https://www.youtube.com/watch?v=XhMBzurjZCU&list=PLiYSIjh4cEx2s8-jXBhv5aCu5_6F9zQ3I

[SamWiseOwl]

It isn't a solution really but could you prevent the slicer affecting the title card by turning off its interactions.
In theory it should make no difference if the title measure and the slicer measures are unrelated but if it does work it will tell you something ...

[Kedar_Pande]

@mikemagill 

Update TestStatic as follows:

TestStatic = 
IF(
ISINSCOPE(CalculationGroupTable[CalculationGroupColumn]),
"Test",
"Test"
)

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[mikemagill]

I'm afraid that doesn't work.

[SamWiseOwl]

So it looks like this but your card changes its value?

That is bizzare!

[mikemagill]

This is a screenshot with two measures selected:

The next screenshot is when just one measure is selected:

The test measure was just to see how pervasive the issue is

[SamWiseOwl]

I feel like the section on Precedence is what you are needing:
https://learn.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprod...

Although if your measure isn't in either 🤔