Issue with expression

[paulwalker]

Hi Community,

I'm comparing two fields using with states, but not giving any value in textbox - same expression if I use in straight table working fine with dimension InsCode.

Can you please correct me for show in textbox ?

=IF(Aggr(Only({2} InsCode), InsCode)=Aggr(Only({1} InsCode), InsCode), AVG({1} AVGSAL))

in text value should be 2804.3333, for those selections  (I'm comparing with InsCode for two states)

PFA,

Thanks in advance!

[paulwalker]

Hi Vegar,

Can we show salary in Measure ? Salary should be matching InsCode Salary (should be 3000 and 38000).

[Vegar]

You don't need that aggregation if you want the valius per dimension row. Try this expression:

=AVG({<InsCode=StateB::InsCode>} Salary)