Forcing Filter selection on a table measure based on Set Analysis when the field being filtered is part of set analysis

[Anonymous]

Hi experts,

I have a scenario where I want a filter selection to apply on a table measure based on a set analysis like this -

measure = Sum({$<PRODUCT_NAME = {$(vMarket1)}>} TRX)

The filter selection is on PRODUCT_NAME. Above measure is ignoring the filter selection on PRODUCT_NAME as it has been used inside set analysis expression. Could you please suggest a work around this ? Thanks!

[isingh30]

= Sum({$<PRODUCT_NAME = {'vMarket1'}>} TRX)

[sunny_talwar · Accepted solution]

May be this:

Sum({$<PRODUCT_NAME *= {$(vMarket1)}>} TRX)

[Anonymous]

Hi Ishtdeep, vMarket is a variable so I am not sure how removing $ expansion would help.

[Anonymous]

Thanks Sunny. That worked. Could you please help understand how adding an asterisk after field name made it abide the filter selection.

Is there any documentation around this which could help. Thanks!

[sunny_talwar]

Yes, there is... check here

Implicit Set Operators

[Anonymous]

Thank You Sunny!