Set analysis in Combo Charts

[mhapanka]

I want to make a combo chart of Primary axis-'NetSalesUSD' as bars and secondary axis-average of the 'Discount%' as markers only for the entries "LRM" in the field 'LRM-MVS' across Regions(Dimension).

The set analysis function I used in the expression for measure is as follows:

=If([LRM-MVS]='LRM' ,[Discount%])

However, this is not functioning and does not take into acount that I need average od the discount %. Could someone help me with this code?

[sunny_talwar · Accepted solution]

May be you need this?

Avg({<[LRM-MVS] = {'LRM'}>} [Discount%])