Crossfiltering issue in calcualtion group

[smpa01]

@AlbertoFerrari @parry2k @bcdobbs @AlexisOlson @BernatAgulloMVP 

TLDR: how can I ensure, the correct cross-filtering happens on other visuals when a calculation item field is clicked?

I am expermeting with a simple data model  which looks like this

and I have made visuals like this

To my surprise, when I click on this, I see test measure being overwritten, I expect this to return 1.

How can I fix this? I don't have paid version of TE, in case it requires that.

Thank you in advance.

[parry2k]

@smpa01 Thanks for the feedback. As you said, if you are not careful with CG you can run into many challenges and that's why I have way too many videos on CGs. I have much more to do as I encounter these challenges but cannot find the time to record.

Appreciate your feedback. Thank you!

[BernatAgulloMVP]

either this or just remove the interaction if you don't need it.

You can also apply the calcualtion group inside a measure, so it's not part of the filter context. 

I general, though, I prefer to specify over which measures it should have effect and leave the rest as they are. You can even set up a calculated table with the names of the measures and then check  the contion IF(SELECTEDMEASURENAME() IN VALUES('affected measures'[measure]), /*do stuff*/, SELECTEDMEASURE())
If you do stuff with the format string then do the same:
IF(SELECTEDMEASURENAME() IN VALUES('affected measures'[measure]), /*do stuff*/, SELECTEDMEASUREFORMATSTRING())

[smpa01]

@BernatAgulloMVP  thanks. can you please provide me an example of what do you mean?

You can also apply the calcualtion group inside a measure, so it's not part of the filter context.

[BernatAgulloMVP]

If you don't need to swap the base measure you can define a new measure that goes like

New measure = CALCULATE ([basemeasure], 'Calc Group Name' [calc group column] = “calc item name“)

You will loose the dynamic format though. The workaround is an extra Calc group, but that's probably overkill

[parry2k · Accepted solution]

@smpa01 you have to eclude this measure in the calculation item. Learn methods to exclude measures in calculation groups with DAX functions and Field Parameters - Yo...

[smpa01]

@parry2k  Thank you very much. You saved my day. The video is awesome to say the least and reveals a very import CG Gotcha.

I could not find anyhting in MS documentation regarding CG Gotchas.

CG requires a lot of babysitting and careful considerations. Also, it would have been nice if there was a way to refrence a measure folder path that conatins all the measures to be excluded, rather than creating a parameter table to utilize dynamic exclusion.

Something like this

Thanks again. You did great.