How to create a measure based on specific slicers but overiding visual interactions

[scastonguay1]

Hello,

The following measure calculates quantity of parts based on specific slicers to calculate a production yield.

TOTAL_QTE_PROD = CALCULATE(SUM(tblQTE_PROD[QTE_PROD]);ALL(tblQTE_PROD))

Is it possible for this measure not to change when user is interacting with other visuals.  The interaction button cannot be deactived because of other columns will need the interaction.

I was thinking of passing the measure value in a kind of variable or the equivalent.

Thank you very much.

Sylvain

[v-yulgu-msft]

Hi @scastonguay1,

With above formula you provided, the returned result is fixed, won't be affected by any slicer filter or interaction filter, because of the usage of ALL() function.

Regards,

Yuliana Gu

[scastonguay1]

Hi,

Attached is a picture that should better explain my current situation.  When a selecting a row in a visual the interaction filter changes the QTE_PROD. 

Hope this clarifies.  An image = 1K words!

Thanks for the quick reply

Regards

Sylvain