Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Vegar,
Can we show salary in Measure ? Salary should be matching InsCode Salary (should be 3000 and 38000).
You don't need that aggregation if you want the valius per dimension row. Try this expression:
=AVG({<InsCode=StateB::InsCode>} Salary)