Using context with calculated variables

[former_member808993]

Hi,

Hoping to get some answers. I have the 5 green columns as calculated measures.

I want to remove Employee - Key and keep Tenure & Classification dim and summarize it like the 2nd table.

It should summarize as

If (vProfit & VPosition & vPay & vTenure & vClass) = 1, Then Unmodified Amount = 1.0000 Else Unmodified Amount for each Employee - Key. What I have in Orange column is the desired output.

I've tried numerous ways but is it possible to use context in calculated figures? When I remove Employee - Key from the table, all the calculated figures (green column) just sum up and the above if statement breaks because it is no longer looking at by Employee - Key.

Thank you !

[former_member808993]

Thank you, was able to resolve my issue. I made the BEx query key figure into a dimension in webi and was able to use context around it.

Thanks for your idea! Wouldn't have thought of making the Amount key figure a dimension.